Processing rows in a file differently based on unique column count
I have a file that has many rows and depending on the number of unique columns in a specific row, I would like to load to different tables in a database. Does anyone have suggestions on the specific Talend components that will help achieve this type of processing? Thanks!
tMap to add a sequence number as a key for each row if it doesn't exists yet. Then tNormalize to create 1 row per field with the key. Now you can count how many rows for a key and decide what to do with the original record.
