How to reverse the sign of the numbers present in the cell in datatable

[shetanshudhar]

Hi Karan,

1. Filter original data table to get only these 3 columns in a new data table.
2. you can multiply specific row values with -1 and save it in the new data table for the required columns 1 by 1.
3. Delete the 3 columns from original data table.
4. Add columns from new data table to specific position in original data table using set ordinal method.

Insert a Column into a specific position in DataTable

Hi @naotosx, I have specified the position of the column using the method setOrdinal in the invoke method activity: [image] The DataColumn.SetOrdinal(Int32) method changes the ordinal or position of the DataColumn to the specified ordinal or position. When you change a column’s ordinal, the column is moved to the new position in the collection of columns. Any columns between the previous and new ordinal will be renumbered, to adjust for a column’s new ordinal. Best Regards, Susana

Hope this helps…