Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Move SQL single record select into Variable for use in Filter Node?

SideOfRanch
8 - Asteroid

I need to take a single date at run time from a SQL database table. SEL MAX(DATE) FROM TABLE. I then want to use this date as part of a filter node. I feel like this shouldn't be hard but my brain isn't working at all.

2 REPLIES 2
Qiu
20 - Arcturus
20 - Arcturus

@SideOfRanch 
Maybe something like this?

0310-SideOfRanch.PNG

fmvizcaino
17 - Castor
17 - Castor

Hey @SideOfRanch ,

 

Here it is.

fmvizcaino_0-1646879359347.png

 

 

Best,

Fernando Vizcaino

Labels