1 - import rules (filter file on rows that contain |) 2 - import lists (filter file on rows that contain ,) 3 - join them together 4 - build a rule checker (see screenshot) 5 - aggregate it back to only show rows that pass 6 - get the midpoint for each row 7 - join datasets 5+6 and get the sum

1 likes 1 replies