DSXchange

I have a one column which has
id,tax_input,tax_amt,tax_address | id,tax_input,tax_amt,tax_address

I want to split this into records based on delimited '|'
id,tax_input,tax_amt,tax_address
id,tax_input,tax_amt,tax_address

this should happen on dynamically based on '|' as record separator.

Which version of datastage you are in.?

I am assuing you are in 8.5 or above version,you can check below post,I have given solution,you need to apply only one transformer,check only logic for tsfm2

viewtopic.php?t=149150

getsatish_gk : use field option for '|' in transformer, then use Pivot stage to convert into rows

If the source file is a text file, you could use a Filter command such as sed or awk to convert the pipe delimiters into line terminators. (Even though you are on Windows, the MKS Toolkit provides these commands.)