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

Referencing a constant cell

reginawhelan
8 - Asteroid

Hi, I am trying to compare dates within my flow. I have two documents:

1. List all the customer details (that will eventually be uploaded to a system)

2. Specific details about the certain group of customers being loaded.

 

I want to ensure the date in document #1 (at customer level - multiple cells) is not greater than a date in document #2 (constant specific cell)

 

Is there a way I can compare this information? 

7 REPLIES 7
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @reginawhelan,

 

Which version of Alteryx Designer are you running?

 

Regards,

Jonathan

mbarone
16 - Nebula
16 - Nebula

Do you have a mock up of the two files with some data, and what you want the final output to look like?

reginawhelan
8 - Asteroid

Hi, I'm working with Designerx64

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @reginawhelan,

 

But which version more specifically? Navigate to the toolbar "Help" -> "About"

 

Jonathan-Sherman_0-1593541664311.png

 

 

 

Regards,

Jonathan

reginawhelan
8 - Asteroid

reginawhelan_0-1593541755952.png

 

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @reginawhelan,

 

You will want to bring both files into Alteryx, my example:

 

Data to filter on:

Jonathan-Sherman_2-1593542401245.png

 

 

File with date to compare against:

Jonathan-Sherman_1-1593542375041.png

 

 

You can then isolate the date you want to use to compare and append to the list of dates to perform a filter and find dates <= date from other file

Jonathan-Sherman_3-1593542426176.png

 

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

 

 

 

reginawhelan
8 - Asteroid

Thank you very much! 

Labels