Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Using a file for dynamic input

miguelboi23
6 - Meteoroid

Hello,

 

New here and need some help. I am trying to query records in the DATA file by the date that I manually set in the DATE file.

 

In the DATA file, the dates are formatted like "10-FEB-2022"

In the DATE file, the date is formatted like "02/10/2022"

 

I can't seem to get them connected. I tried formatting the dates the same and it still doesn't work.

5 REPLIES 5
binuacs
17 - Castor

@miguelboi23 Can you upload your input files as well?

miguelboi23
6 - Meteoroid

Attached. Thank you. 

ScottE
Alteryx
Alteryx

Hi @miguelboi23 

 

You can use the Date Time Parse tool to convert your strings to dates and then I'd append your conditions.

The attached will solve for the inputs you provided and you can probably use an IF/THEN statement if you have a more complicated set of conditions. 

 

Hope that helps,

Scott 

binuacs
17 - Castor

@ScottE One way of doing this

 

binuacs_0-1670282039734.png

 

miguelboi23
6 - Meteoroid

Awesome. Crystal clear. Thanks so much for your assistance and input!

Labels