One Star

Load distinct values from csv file

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?
One Star mpa
One Star

Re: Load distinct values from csv file

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.