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

Referencing a constant cell

Highlighted
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? 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @reginawhelan,

 

Which version of Alteryx Designer are you running?

 

Regards,

Jonathan

Highlighted
13 - Pulsar
13 - Pulsar

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

Highlighted
8 - Asteroid

Hi, I'm working with Designerx64

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @reginawhelan,

 

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

 

Jonathan-Sherman_0-1593541664311.png

 

 

 

Regards,

Jonathan

Highlighted
8 - Asteroid

reginawhelan_0-1593541755952.png

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

 

 

 

Highlighted
8 - Asteroid

Thank you very much! 

Labels