Load distinct values from csv file

Anonymous — Sat, 16 Nov 2024 12:44:03 GMT

How to load in a target table from a delimited file having more than one same value in a column. I have to take the distinct values of the column.
please help how can i do it?

Re: Load distinct values from csv file

Anonymous — Thu, 18 Aug 2011 15:02:47 GMT

nirmallyakoley,
You can achieve this by using a tAggregateRow component in your job.
tfiledelimitedinput --> tAggregateRow --> etc..
In the tAggregateRow add all your columns to the groupby and you will get the distinct results.
Regards

topic Re: Load distinct values from csv file in Talend Studio

Load distinct values from csv file

Re: Load distinct values from csv file