databasetalendtmapdata-integration

How to transform a list of numbers into seperate elements talend tmap

I have a list of codes for each state as an input stored in a table.

enter image description here

What I want as output is this , using tmap transformations

enter image description here

This is the job I made but it doesn't seem to work correctly like I want. The output should have 1000 rows. enter image description here Does anybody know how to solve this?

Solution

  • One way to do this is to convert your list to a string of comma-separated values (using tConvertType for instance) and then use tNormalize to split this string into individual rows.