How to change the position of a row in datatable

Hi Team,

I have datatable dt like this

Column1 Column 2 Column 3
Agnes 232 0098
Total 2323 329809
Capital 12312 12312
Arc 2321 213213

I need change the position of the row to the last position in datatable if the row(0) = Total

for ex. I have Total in the row 2 then I need to change the position to the last row of the datatable.

@Karan28 Check this workflow :
ShiftRows.xaml (8.9 KB)

What I have done is :

  1. Get the Row having Total in it’s First Column
  2. Convert the Row to Object Array and Store it.
  3. Delete the Total Row from the Datatable.
  4. Use Add Data Row Activity with Object Array as the input value which in turn contains the total row value.

Let me know if it doesn’t work.


Hey thankyou so much fir this , seems like the correct logic applied. I’ll check and get back to you

1 Like

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