How to filter CSV file with duplicate Colum header

[Vincent_Nuestro]

Hi i wanted to filter my CSV file but i have a Duplicate Header.

Condition:
if “Person Number” in (Excel) have same “Person number” in CSV

• Get the Assignment Number starts with Letter “E”

Else

• Skip

Thank you In advance
-Vincent

[Yoichi]

Hi,

For now, the following will help for handling duplicated column header, for example.

Sample20210924-1.zip (7.8 KB)

Then we can use Join DataTable etc to get AssignmentNumber.

Regards,

[Vincent_Nuestro]

Hi @Yoichi i dont know why it gives me the whole column header at the very 1st loop?

[Yoichi]

Hi,

Can you share your workflow and csv data, if possible? It’s difficult to understand what happens from the above image.

Regards,

[Vincent_Nuestro]

Hi @Yoichi
please check

Main.xaml (8.1 KB)
Processing: FULL extract (employee roster) v20180308.csv…

[Yoichi]

Hi,

Thank you for sharing. However, cannot download the csv file. Can you check it? Dummy data is ok if it reproduces the problem.

Regards,

[Vincent_Nuestro]

FILTER_CSV.zip (11.4 KB)

uploading the zip file thank you

[Yoichi]

Hi,

Can you modify from Tab to Comma at Delimiter property of ReadCSV?

Regards,