topic Processing rows in a file differently based on unique column count in Talend Studio

Processing rows in a file differently based on unique column count

Anonymous — Wed, 19 Jul 2017 22:03:23 GMT

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!

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

TRF — Wed, 19 Jul 2017 22:58:43 GMT

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.