Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filtering for patchy history

lcoombes
5 - Atom

Hi everyone,

 

I have a data table like the below

 Year 1Year 2Year 3Year 4
Service 159  92
Service 2 100115120
Service 3  200151
Service 498766599
Service 5 24 63
Service 610099 84

 

I want to analyse the services with 2 years of data separately to those with more than 2 years available. 

 

So the data would be split into two tables like these:

 

 Year 1Year 2Year 3Year 4
Service 159  92
Service 3  200151
Service 5 24 63

 

 Year 1Year 2Year 3Year 4
Service 2 100115120
Service 498766599
Service 610099 84

 

Does anyone have any idea how I might do this?

 

Thank you very much in advance 🙂

2 REPLIES 2
mmenth
11 - Bolide

Hi @lcoombes,

 

The attached worked for me! Essentially you transpose the data, remove empty/nulls value fields, count the remaining, split the data using a filter based on your criteria, then join each set back to the original, removing the right join data fields.

 

Best,

mmenth

lcoombes
5 - Atom

Thanks so much for such a quick reply @mmenth, very clever!! Much appreciated 😀

Labels