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.
Try Talend Cloud free for 30 days.
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.