How to swap the Data table columns

[Bachi_N (R@ghuram)]

Hi All,

I would like to swap the second and third columns of the data table using Uipath activities .

Can someone please help me to resolve this with sample .xaml

Thanks

[Divyashreem (Divyashree Muddagangaiah)]

Use Build data table and create a table with the order you want and loop the data table which you have and pass the array of values to new data table.

Else write that to excel and use short cuts to modify and again use read data table.

[lakshman (Ganta lakshman)]

@Bachi_N

Welcome to the UiPath Community. use Invoke Method activity and set MethodName as SetOrdinal Method. Please check below thread and follow the steps.

Swapping the columns

Once you have the DataTable in memory, you can use the SetOrdinal method to change the order of the columns, via the Invoke Method activity. [image] Then you can save back to a CSV file. Here is the workflow that swaps two column in a data table, in memory. Main.xaml (8.7 KB) Regards Silviu

[amaresan (Amaran)]

Hi @Bachi_N

You have two Option

1. One is you can use Set Ordinal Method
2. second one is dtTest.DefaultView.ToTable(true,“Column1”,“Column3”,“Column2”)

Regards
Amaresan.P

[kadiravan_kalidoss (Kadiravan K)]

Please refer the link below:

How to change the datatable column sequence

I read excel by using read excel and stored data in datatable, now i want to change the datatable column sequence. Please give solution.

[Bachi_N (R@ghuram)]

Thanks