I'm using one data table and in that data table consider we have 200 items, out of 200 items I want to move particular item having column name as "Record" and value assigned for that column is consider "ABC" I want this row to move at last of data table

Looking for solution from long time as I have to move the current row item to last, to process on it at the end

Hi @SohamPatil,

There can be many approaches to this solution but the one that’s coming in my mind right away is as below:

  1. use filter data table activity and keep rows where record column is not equal to ‘abc
  2. use another filter data table activity and keep rows where column is equal to ‘abc’.
  3. now you have 2 data tables, the one from step 1 does not have any rows where record column is abc and 2nd data table only have rows where record column is abc.
  4. use merge data table activity and merge 1st data table with 2nd. This will make 2nd data table items get appended to the end of 1st data table.

Hope this helps.

Regards
Sonali

2 Likes

Thank you @sonaliaggarwal47 it worked for me

2 Likes

Hi @SohamPatil,

I am happy to hear that!

Can you please mark my above post as solution so this topic can be closed and help others.

Regards
Sonali

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