0'zero' already belong to this datatable

System exception at initialization: A column named ‘0’ already belongs to this DataTable. at Source: Add Data Column

HI @guptasweb

The column name “0” is has duplicated in the excel file.

Rename the column name which has duplicate

Regards
Gokul

In Your Dt you have 0 [Column name] already. Try to add with the different name in the Add Data Column @guptasweb

1 Like

Can you share the screenshot of that particular datatable in excel or in build datatable? @guptasweb

I think so somewhere the header is replaced with zero or if zero is the actual header name the datatable has the duplicate header name

Regards
Sudharsan

Instead of 0 you can add something 01 based on the requirement @guptasweb

image

right now, I am not using any build data table activity, I am simply copying the data still I am getting this error.

Instead of using 0 as the column name try with any Character and check it @guptasweb

1 Like

Can you confirm that your inserting the header in this sheet @guptasweb

What is the value comes from the item @guptasweb ?

@guptasweb

What is your task ? Can you elaborate ?

Regards
Sudharsan

Actually, right now I am transpose the data from output into new sheet when i am transpose this data I am getting this error:
Errors:
Add Data Column: A column named ‘0’ already belongs to this DataTable.
System exception at initialization: A column named ‘0’ already belongs to this DataTable. at Source: Add Data Column

Can you share the sample input and output excel @guptasweb

1 Like

Hi @guptasweb

Check out this docs

Or Install this package

Regards
Gokul

Input-


Output-

This shows some error

HI @guptasweb

Check out this XAML file

Transpose.xaml (7.0 KB)

Regards
Gokul

image

which activity you are using?

HI @guptasweb

Check out this link