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

Dynamic selection of columns (If they are present)

ninjaboy12345
5 - Atom

Hi Team,

Have a problems with my workflow, 
essentially we have a daily report for each client. Let's say they it outlines how many boxes of chocolate and regular milk they buy from us. In the morning we get names of clients who have changed their buying order by more than XXX, so we need to look into their yesterday's and today's orders and see how much of a difference there is in each row(location for which they purchase).
Now the questions is, some buy only one milk and some buy both, how can I put that in the flow to only do those columns that are present? 

3 REPLIES 3
kat
12 - Quasar

Hi @ninjaboy12345

 

Could you perhaps post some sample data to further illustrate this? That'll make answering a lot easier! :)

 

Cheers

Kat

ninjaboy12345
5 - Atom

It might be as simple as that. And all I need to do is find the difference between them, but sometimes they will only have the location and Chocolate column and no Strawberry column. I want it to do the comparison only if there are columns present

Ladarthure
14 - Magnetar
14 - Magnetar

Hi,

 

I did a sample workflow for your problem. The idea is to transpose both files (day1 and day2) and then compare them, you could filter at the end if you only want to show the locations where there are changes.

Labels