Hi , I am having one complete line e.g 1|null|test. I have to replace null with the ""(empty string) in Talend . its a complete line and not a separate column.Because in our case its dynamic column content which are coming into one single column..?
Then whatever you are saying is possible... you'll need more than one tMap to achieve this. Just make sure layout of the file does not change during transformation. One more thing, tSetDyanmicSchema component supports only positional file. For any other file type (Delimited, etc.), dynamic schema is your best bet.