Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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
I was able to do this essentially with the Summarize tool, but I was looking for something else initially: It would be great to have a function that works like an on/off switch, as in: "if I encounter this value then 'on' (eg '1'), if I encounter it again then 'off' (or 0)" (This principle could repeat)
Surprisingly, I couldn't find such!
I didn't read the question on the forum, just in the workflow and so made my answer to work if an ID was to appear >2 times. Little iterative macro..
スポイラ
The Workflow:
And the Macro:
Two approaches:
- A good approach to solve it with a couple of tools.
- A heavily manual approach using Samples to get the output.
Way happier with the first approach though.
