Hi,
Looking for some help with the below. Not sure if this is doable.
I have a workflow which uses a filter tool to see if it satisfies a condition and split it into true and false outputs. I need to take all the data from T output and few records from F output.
For example Bob Smith has 4 records in T output then I need remaining 6 records from F output. In total I need 10 records for each person. Now another person Shane Williams has 6 records in T output then I need 4 from F output.
I used group by function to get the count for each person but not sure how to implement the above logic as the number of records keep varying for each person but I need 10 in total taking all records from T output and remaining from F to have 10 in total
Data as below
ID Name
1 Bob Smith
1 Bob Smith
2 Shane Williams
2 Shane Williams
2 Shane Williams
3 Robert
3 Robert
3 Robert
3 Robert
After using condition in filter
T output
ID Name
1 Bob Smith
2 Shane Williams
2 Shane Williams
3 Robert
F output
ID Name
1 Bob Smith
2 Shane Williams
3 Robert
3 Robert
3 Robert
