Referencing a constant cell

[reginawhelan]

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? 

[Jonathan-Sherman]

Hi @reginawhelan,

Which version of Alteryx Designer are you running?

Regards,

Jonathan

[mbarone]

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

[reginawhelan]

Hi, I'm working with Designerx64

[Jonathan-Sherman]

Hi @reginawhelan,

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

Regards,

Jonathan

[reginawhelan]

[Jonathan-Sherman · Accepted solution]

Hi @reginawhelan,

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

Data to filter on:

File with date to compare against:

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

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]

Thank you very much!