I am trying to create a for loop (Batch Macro)

[christopherKiener12]

for each File ID take the first 160 records where the risk numeric is the highest and where flag = 1. I assume this would be a macro solution just cant figure it out. Here is a sc of the fields. 

Also attaching some data  

[binu_acs]

@christopherKiener12 Do you have the expected result?

[christopherKiener12]

The expected result would be 160 records for each file ID. where risk number is highest and where flag = 1.   I think there are 12 file ID (1-12) so 160X12 = 1920 records as the output 

[christopherKiener12]

Another way to put it would be 1920 ID's ranked based on the loop criteria provided 

[binu_acs]

@christopherKiener12 Attaching the workflow, I had to create two batch macros for your use case, let me know it works for you