Rearrange columns from one datatable to another


So I have a datatable:

and I want to rearrange it to another datable like this:

Any suggestions on how to do this?
Thank you

Assign dt = dt.DefaultView.ToTable(false, dt.Columns(1).ColumnName,dt.Columns(4).ColumnName,dt.Columns(3).ColumnName,dt.Columns(2).ColumnName,dt.Columns(0).ColumnName)

@RailCay You can also use Filter Datatable Activity, in Keep Columns Section, Provide the Column Names in the Order you want it.

1 Like

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