Rearranging columns in a DataTable

[shrayud (Shrayus)]

Hi,

I need to change the format of a DataTable by rearranging columns and including blank columns in-between. Can you help help me the process to do so.

PFA the old_csv and preferred_csv.

[Hiba_B (Hiba Beldi)]

Hi @shrayud !
I don’t know why but I have an error when i try to unzip your folder.
Anyway, to add columns, you can use “Add DataColumn” activity and precise the index you want the column to be added and give it a dummy columnName
To change the position of the columns, I use an artisanal way: by using Filter datatable activity, and add all the columnNames at the column field in the wanted order. I am sure there is a better way, but for the time being it’s a clue

[prasath17 (Guru)]

@shrayud

DataTable by rearranging columns

For Rearranging the table columns you can use Set Ordinal method in the invoke code activity using the below code:

Dt.columns(“yourcolumnname”).setordinal(5)

I just gave 5 as an example here.

[shrayud (Shrayus)]

Hey thanks:

error BC30451: ‘dtCheck’ is not declared. It may be inaccessible due to its protection level. At line 1

This error is coming. dtCheck is my datatable

[prasath17 (Guru)]

Oh sorry…you have to use Invoke Method activity.

I will share the sample once I am back.

[prasath17 (Guru)]

hi @shrayud … Please find the sample below…

My Input:(Status column is 2 i.e. index 1 (index starts of 0)

Invoke Method ( here I gave, so that Status column will be moved to 0)

You can see the output in my first screenshot.

Hope this helps…

[shrayud (Shrayus)]

Thanks,

I also need to delete few columns like in your case:

[ID Status Value Date] It needs to be

[ID Date Value] I want to remove status column while rearranging; can I do so using Invoke activity

[prasath17 (Guru)]

@shrayud - You can use “Remove DataColumn” Activity and give ColumnIndex as 1 (in your case)…

or you can use…“Insert\Delete Columns” inside excel app scope …and choose remove in the property and give the column positions…

[shrayud (Shrayus)]

Thanks