I need add one column in existing datatable

I tried to add one column(column name: Status) with existing data table using Add data column activity, It is adding two column but i need only one column (Status).
I got below output

My Add column property
image

Hi @BNK

  1. Use Excel File activity
  2. In ExcelPath → Give you excel file Path
  3. Use Insert Column activity.

Or
You can try with Write Cell activity
image

Regards
Gokul

Hi @Gokul001 It is not adding properely. and In this project i am not using modern activities.

Hi @BNK

Think the column1 is already present in your datatable,we can remove this column by using remove data column activity before writing the datatable back into the excel.

Thanks

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.