I have a scenario , which contains comma separated values in 2 cells , I need to normalize both Fields .Like ,
I need the output as :
# I tried with tNormalize ( 2times for Product , Qty Fields) but rows are getting repeated with that.
Please give me a solution for that.
Thanks in advance
Quest would be
1) 1st Normalise Product Col , add counter to each record number .
ID, Name , Product , Counter
2) Again for Quantity Col.
ID, Name , Quantity, Counter
3) Do inner join between three columns ID, Name , Counter
You should have your answer.
Thanks for the response @akumar2301
In first Normalization , I did with "Product" , on 2nd one with "Qty" .
Then on each flow , I omitted Qty column( 1st flow) & Product column( 2nd flow) through tFilterColumn.
But , after that , in tJoin/tMap , I cannot map from 2 different filter Outputs , hence , cannot join 2 incoming flows.
Note : Solution without "Counter" column is desirable.
You cannot do that please follow below link
tJoin/tMap might not work for your case without an a counter. as for same id and name , you will have more than one entry in table.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
View this on-demand webinar about APIs....