Processing rows in a file differently based on unique column count

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!

Fifteen Stars TRF
Fifteen 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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now