How to reorder columns in datatable

Help
1

I have datatable with columns: URL, Location, Name. I need the ‘Name’ column as the first column. How do I do this?

2

Hi @shrutika

You can find your answer over here: :slight_smile:

3

I tried the given solution but I keep getting this error error

This is the invoke method:

invoke%20method
invoke%20method919×348 36.1 KB

Is there a way other than invoke method?

4

@shrutika did u set parameters in properties? Check also whether u assigned readrange output to datatable varibale u have declared

5

What parameters do I need to set?

6

@shrutika u have set target column number to where column name in invoke method should be moved.

Capture

above image is parameters property Like above image value represents to where u present column has to be moved. In image i am moving to first 2nd column(since column numbers starts from 0)

7

Thank you

8

Hi @shrutika

Here is a detailed article on that :slight_smile:
# How To Reorder Columns In DataTable – In UiPath

Regards,

4 Likes
9

Hello Shrutika,

Try this, Use Filter Table Activity and then without adding any filter go to Output Columns section, here specify the order you want. Its easier this way and you have complete control over the range which you dont using thei invoke method.

Hope this solves the problem.

Better late than Never

11 Likes
10

Excel application scope

Modify the EXCEL file name

11

Hi mapkar,
This method is working can u explain your mode of approach

thanks and regards
Sankeerth.T

12

Filter Data Table Activity

1 Like
14

In addition, Use the same DataTable variable in InputDataTable and OutputDataTable in Filter Table Activity.

15

Nice job, this is exactly what I needed. This should be marked as the solution.