How to Retain Duplicate columns without bug when reading a CSV

Hi @Will.truong09

The solution is to micro-manage it a bit.

Use Read CSV file activity with those settings:

You will end up with a Data Table with generic column names that aren’t duplicated plus your column names in the first row.

It is not possible to create a Data Table with multiple columns with the same name, so you will need to act accordingly.
Input file:
image

Output Data Table:
image