Referencing a constant cell

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?

Developer

Accepted answers

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

Which version of Alteryx Designer are you running?

Regards,

Jonathan

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

Hi, I'm working with Designerx64

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

Thank you very much!