How to cope with this issue

Can anyone know / help me to solve this issue? Many thx!
Problem:

target format:

workflow:
Main MU-bias (cal3.xaml (32.8 KB)

@Happydayyy

Did you try this activity

Cheers

Simple sort will not work because there is not any unique key to use for sorting.
If I understand well your requirement you want

  • take row with “No” 1
  • then take five rows with empty “No”
  • take row with “No” 2
  • take next five rows with empty “No”
  • and so on…

You would need to

  • split your table into two tables
    – table1 with “No”
    – table2 with empty “No”
  • sort table1 by “No”
  • for each row in table 1
    – take the row from table1
    – take 5 rows from table2

Cheers

@Happydayyy

HappyDayyssss.zip (103.5 KB)
Please find the above attached xaml hope it works for you

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