Four Stars

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!

  • Data Integration
1 REPLY
Nine Stars TRF
Nine Stars

Re: Processing rows in a file differently based on unique column count

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.

TRF