Need help right here. I have csv files with 18 headers. The values are separated by semicolon and it contains duplicated column names!!
First problem: Read CSv activity throws an error as there are duplicate names.
Second, I tried to exclude option “include Column Names”. What happened then? CSV throws an error as the columns format is mixed with and without quotes
What I am doing so far: as I only need the last row to be the header, I deleted the header using invoke VBA inside excel application scope. Problem is, after excel read this and perform action, somehow UiPath recognizes the values as comma separated!
And if I go further with it by using comma as the delimiter and use write range activity to export it to excel, it did not even separate the values
As visual aid, below is how the header looked like.
thank you for your helps.