Output & Read Alteryx Database within same workflow

[cetricelaens]

I have a workflow with 2 set of streams. In first stream am outputting the data into Alteryx Database.

Second am reading the same Alteryx database as Input. Should be completed within same workflow.

Can we do that ?

Thanks! 

[afv2688 · Accepted solution]

Hello @cetricelaens,

Yes, indeed you can do this. You could write two macros, one to write the data into an yxdb an the second one to acces them.

It is possible and I have done it many times. Just remember to put (or to have the write macro being executed first).

Regards

[CharlieS · Accepted solution]

Check out the Block Until Done tool in the Developer category.

https://help.alteryx.com/2018.2/BlockUntilDone.htm 

I suggest establishing a file path string, and using that to write the output file, then the Block Until Done tool can subsequently pass that to a Dynamic Input tool to read the file at that path. Check out the attached workflow for an example.