Hi Alteryx Experts,
I have a use case where I have been collecting user logins over the past few months. I need to be able to select certain columns of data and provide a single list of users for that date range.
So for example my data looks like the below:
| day 1 | day 2 | day 3 | day 4 | day 5 |
| john | sally | john | john | fred |
| sally | george | peter | sally | tom |
| mike | tom | sally | peter | john |
| peter | mike | fred | tom | ted |
and I want to see who logged in for day 3-5, so my desired output is:
| Users: |
| john |
| peter |
| sally |
| fred |
| tom |
| ted |
I'm trying to do it in a way that I would be able to add and select different columns as time goes by to keep an up to date "active" user list for my application. I actually also have multiple sources for the login logs so would want to be able to combine and dedupe the lists once each log has a single list.
So far all I have been able to achieve is sorting the columns I want to use, but am at a loss on how to get the dedupe logic working across multiple columns and outputting to a single column. I've tried transposing, unique tool, join multiple tool, etc but I am stumped!
Please help!
