How to reverse a DataTable?

[shreyasshete]

How do I Reverse a datatable?
Meaning, rows starting from say from 1 to n should become from n to 1!
How can this be achieved?

Thanks and regards,
Shreyas

[Jan_Brian_Despi]

Hi @shreyasshete,
Maybe this thread helps:

For each reversed

Hello. With arrays you can use .Reverse() For each item In arrayvar.Reverse For data table, you just need to use a generic For each activity then add .AsEnumerable and change the Argument type to DataRow For each row In dt1.AsEnumerable.Reverse Regards.

Thanks and regards.
Despi

[shreyasshete]

I had tried it but unfortunately it did not work out for me as it was throwing error in for each activity!

[Jan_Brian_Despi]

Oh. Okay. Can you upload your workflow?

[Manjuts90]

@shreyasshete Try Like below it will work.

dt1 = dt.AsEnumerable.Reverse.CopyToDataTable

where dt and dt1 are datatable variables.

[Jan_Brian_Despi]

@Manjuts90

@shreyasshete Try Like below it will work.

dt1 = dt.AsEnumerable.Reverse.CopyToDataTable

where dt and dt1 are datatable variables.

This one posted by @Manjuts90 works!

[shreyasshete]

Sort DataTable also helps if any column can be arranged in descending order

[Jan_Brian_Despi]

You’re right