Using data from one input in an unconnected workflow

[marksyoung73]

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

.

[mbarone]

Would a simple Join tool do the trick? 

[MichaelSu]

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

Thanks,

Mike

[marksyoung73]

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]

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]

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

[mbarone]

Welcome - great to hear!