How to solve same column name error in datatable?

Help Activities
, ,
1

Good Day.

May I know how to solve same column name error in datatable? Thank you

Best regards,
Robert

2

Coming from:

  • Excel readin

Or

  • Data Column Addition

?

3

Don’t try to create a datatable with two columns that have the same name.

If you want help for your specific situation, you’ll have to tell us your specific situation. “how to solve this error” doesn’t tell us anything.

2 Likes
4

Hi @postwick

I am having this kind of error where the text file (Sample Input.txt) where I need to transfer it into excel file (Target Output.xlsx).

image
image1410Ă—988 63.3 KB

Sample Input.txt (33.1 KB)
Target Output.xlsx (26.1 KB)

Thank you.

Best regards,
Robert

5

please share with us the used regex.
As mentioned in other topic, that a cleansing of the data is recommended, you would adress this part:

grafik
grafik1162Ă—141 22.3 KB

and work on handling the column names spanning over two lines

6

Your column headers are split across two rows. So instead of columns named Market Price and Market Value, it’s trying to create two named Market.

What I suggest is converting it without headers. Then manually rename the columns.