2024: Week 52 - Solution
Solution by Tom Prowse and you can download the workflow here . Step 1 - Split Nice or Naughty After inputting the data we can then start to split out the names on the Naughty or Nice list and the order in which they are on the list. First we want to split the List and Order from the File Paths field. We can do this using an automatic split or using a split on the space. We can then rename split 1 to List and split 2 to List Order. Step 2 - Index & Score Next we want to create an index field by combing the File Path number and id. Index ([List Order]*100)+[id] From here we can then calculate a Nice and Naughty Score: Nice Score {FIXED [first_name]: SUM(IF [List] = 'Nice' THEN 1 ELSE 0 END)} Naughty Score {FIXED [first_name]: SUM(IF [List] = 'Naughty' THEN 1 ELSE 0 END)} Then finally we can determine what list each name should be on based on their scores. Nice or Naughty? IF [Nice Score] > [Naughty Score] THEN 'Nice' ELSEIF [Naugh...