Deduping across Multiple Columns to Single Output Column

[barnese]

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!

[Jonathan-Sherman · Accepted solution]

Hi @barnese,

You could start by transposing and doing a little bit of preparing:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Zas3NfkB]

Hi @barnese you can do it fairly easily by pivoting the data then using a filter tool. For this case a simple OR function was used but depending on the size of the data, you could make it more dynamic. 

[barnese]

Thank you!  Both of these suggestions are working to get the unique list.  I can provide a filter based on timestamp so it is very helpful!