We are in the final days to enter our Data and Analytics - "What's your why?" raffle with SparkED!

Reply with your "why" in text/video format to our forum post by January 28 to be entered! 

Alteryx Designer Discussions

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

Using data from one input in an unconnected workflow

marksyoung73
6 - Meteoroid

Hi,

 

In the below image, is there a way I can use the field data from my second input in the filter in my first workflow?

 

I only started using Alteryx a couple of days ago, so it's all pretty new.

 

Thank you in advance

 

.Q.PNG

6 REPLIES 6
mbarone
15 - Aurora
15 - Aurora

Would a simple Join tool do the trick? 

MichaelSu
Alteryx Alumni (Retired)

Hi @marksyoung73 ,

 

I would recommend the Parallel Block Until Done macro. This will allow you to complete the first part of your workflow and use the output as an input. See attached. You can also download the full set of Crew Macros here: 

 

https://community.alteryx.com/t5/Engine-Works/Crew-Macro-Pack-2016-Q2-Release/ba-p/26482

 

MichaelSu_0-1627489265336.png

 

 

Thanks,

Mike

marksyoung73
6 - Meteoroid

Ideally, if there is a formula available I would prefer that (almost like a DBRef?). If I used a join I didn't know if I could do a "less than" in my filter with this input?

thanks

mbarone
15 - Aurora
15 - Aurora

Ah - less than - didn't catch that.

 

Is it only the one value that it has to be less than?  If so, then the simplest native tool way to do it would be to use an append tool to append that one date to every record, then you can use your filter tool.

marksyoung73
6 - Meteoroid

Thanks mbarone, That worked, you are a star. Simple but effective.

mbarone
15 - Aurora
15 - Aurora

Welcome - great to hear!

Labels