Hi Friends
I need to write Alteryx Results in to DB Tables. Before writing, I need to check is there any data available in Staging table. If available write data into Archive Table and then write data to Staging. To handle this, I follow below steps.
However, when I execute Query, both output files are executed, instead of one output flow.
I thought, enabling/disabling containers will sort out issue. But, I dont know how to pass filter values to Containers. Please suggest me best practice to implement this.
In the below flow Output Data (105) Should not be executed as Filter conditions fails there.
Thanks
Antony
Solved! Go to Solution.
Hi @Antony89anto ,
the Filter tool evaluates the condition, but unfortunately both results are executed. A possible solution could be to create a macro for the "write to file" part and use the Detour tool to decide, which part should be executed. I've attached a sample workflow writing to either F1.csv or F2.csv depending on the number of rows in an input table. What do you think?
Best,
Roland
Hi Roland
Thanks for your Support. I am not able to open this file. I am using version 2019.4.8 and seems like you r using higher versions. Is there anyway around?
Thanks
Antony
Right click the file and open it in notpad. In there you will see a line which looks something like this:
<AlteryxDocument yxmdVer="2020.1">. Change the number in blue to 2019.4.
Thank you Roland!
One more question. Can't we do this with Containers?
Thanks
Antony
Thank You Abilash!
Thanks
Antony