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!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema