Data scrapping with empty column value

[Eesh_Tyagi]

When data scrapping an table from a website if first row has empty column value then that column is reordered to last. How to we fix the order of columns while data scrapping?

[vvaidya (Vinay Vaidya)]

Can you get get the data into a datatable and try the following

table.DefaultView.Sort = “LastName asc”;

[Eesh_Tyagi]

That didnt work. It gives the same output.

[vvaidya (Vinay Vaidya)]

Don’t have access to computer now.Check below

Uipath - Sort Datatable

Hi, I’m trying to sort a datatable variable which come from a .csv file. I would like to sort the column name: “Column2”, ¿How it could be posible just using the uipath posibilities? ( Not writing in an Excel… ) I´ve been trying with the table.defaultview or table.select properties but i’m not able to sort it. How it could be done? Cheers, David

[Eesh_Tyagi]

Hi,

I was able to rearrange the “Lastname” column using SetOrdinal method of datatable.

[Vindhya_Poovaiah (VP)]

Could you please provide the xaml for the same?