i am retrieving a data from a table which has pipe "|" seperated data. I need to extract the data into different fields. I tried using tExtractDelimiterFields; but it is seperating the data per character.
My data is 5203011|ABC||DirectPartner|Active
I need it extracted by | seperation into
Solved! Go to Solution.
Could you please post your tExtractDelimiterFields schema setting screenshot on forum?
Great this issue has been fixed by yourself. Thanks for your feedback.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.