Add Data Column - A column named already belongs to this DataTable

Hi,

Getting this error while running from Assistant:
Add Data Column (Write_Status): A column named ‘Write_Status’ already belongs to this DataTable

but it’s running fine when running in studio.

Can you please help to resolve.

Hi @Rohit_More ,

Could you maybe let us know what does the total workflow do ?

Will it write the Modified data back to the same Excel sheet ? If so, in the next run the added data column is already present and hence we might be receiving the error mentioned.

Hi @supermanPunch

Bot is reading an excel, processing it, then adding few columns to add completion status, then reading another excel (history of previously completed transactions), and mergin both the datatables and write to eexcel.

It’s coming for first transaction only, also I have checked whole workflow and there is no other Add Column activity.

Thanks

@Rohit_More ,

Could you maybe try to Debug at the point of Add Data Column activity and check what are the column names present in the Datatable ?

Could you also maybe let us know what is meant by the First Transaction here ?

Hi @supermanPunch

When I tried debuggin it’s working fine, columns are also as expected, issue in while runing throught assistant.

Transaction means excel file, it’s having multiple excel files, and reading one bye one and processing it.