Remove Duplicate CVS

Hi,

if I want to remove duplicates from an xslt it goes with “remove duplicate rows” , it doesn’t work with a “csv”, have anyone tips?

THX

Use read csv activity with csv file path as input and get the output with a variable of type datatable named dt
And then that dt can be used as input to REMOVE DUPLICATE ROWS activity

Cheers @BjoernMikolajewski

Hi @BjoernMikolajewski,

Use the csv activity to output your csv into a datatable variable.
image
Then use the Remove Duplicate Rows activity.
image
Documentation about this 2 activities can be found below:


this doesn’t work :frowning:

may i know what was the issue you were facing
Cheers @BjoernMikolajewski

@BjoernMikolajewski

Are you writing the output into the excel/workbook? The result will be a datatable without duplicate rows.

It worked, thx :slight_smile:
I use the write csv aplication

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.