Here is the structure of the file :
We want to transform it to something like :
That's just a sample, the file we have is 6000 items
Solved! Go to Solution.
you can achieve this with help of tnormalizerow and numeric sequence routine.
using tnormalizerow and sequence routine you will have to generate following
id seq country code seq country_name seq
1 1 cm 1 cameroon 1
2 2 fr 2 france 2
3 3 fr 3 united states 3
after this you can perform join operation on seq column
and you will get
This is applicable for n number of records
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