Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Challenge #286 BF: Who turned the lights off? - My Workflow Solution
Spoiler
Idea Flow:
1. Filter out actual Operative values and Animal text placeholders.
2. Isolate Unique Operative values.
3. Find Unique Operative values in the Animal text placeholder data Article title column and add found Operative in a new column.
4. Rename this new operative match column as Operative.
5. Union 309 actual Operative values records with 93 Animal text placeholders (now matched as operatives) records.
6. Group by Operative and Count Article Titles alias as Incident Count.
7. Sort Incident Count descending.
1. Filter out actual Operative values and Animal text placeholders.
2. Isolate Unique Operative values.
3. Find Unique Operative values in the Animal text placeholder data Article title column and add found Operative in a new column.
4. Rename this new operative match column as Operative.
5. Union 309 actual Operative values records with 93 Animal text placeholders (now matched as operatives) records.
6. Group by Operative and Count Article Titles alias as Incident Count.
7. Sort Incident Count descending.
My version of solution
