Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Filter on Dynamic Pivot - Transpose

Highlighted
8 - Asteroid

Hello Everyone,

I'm not entirely sure how to dot his so I thought i'd post it here.  I have a workflow that generates a list of users and their timecards and checks to make sure they enter enough hours in the week for their timecard.  If they do I place an "X" in the week and name, if not I put the hours they've entered (or 0 if none).

 

The data spits out looking like this

 Name Week 1 Week 2 Week 3 ...

Name                3/2/19              3/9/19                 3/16/19
Billy X X 20 Joe 10 X 10 Jane X X X

Is there a way to filter it so Jane falls off the final list?  If I do a filter prior to creating the transpose I lose the X's that Billy and Joe have.  The week names change, they are whatever week end date is occuring when this runs.

 

 

Highlighted
17 - Castor
17 - Castor

Hi @ISUGraber 

 

Before your crosstab, put in a filter that returns any record that is not "X".  Get the unique users from this list and join it to your pre-transposed data.  That will filter out Jane and pass all the other records through

 

Edit:  Here's what it looks like

 

WF.png

 

 

Dan

Highlighted
12 - Quasar

Hi There!

 

Try the attached treatment; hope it helps.

Highlighted
8 - Asteroid

Thank you both for replying!  Both of your solutions were great!

 

 

Highlighted
12 - Quasar

You are most welcome!

Labels