This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I tried creating the WF following the steps you mentioned.
It seems that the message tool does block the records but the headers are passed crossing the join to process in my WF.
I basically want to union the join out (LRJ) and do a check afterwards in the WF (I am using the multi field formula tool to force all columns to v_string due to nulls the fields can have different data type.)
What i want is if any one of the data set is empty, it should not proceed to the Join tool causing the WF to Fail.
Firstly, I cannot run your workflow as the data is pointing at your local machine; in order to create a 'transferable' workflow you need to look at using the 'export workflow' option available under options. This will create a 'zip' file which includes your data.
Then we can help you come to the solution you need, though I'm not sure what the problem is. Your workflow will not write data to any output if there are any 'fatal' errors in your workflow (that's my understanding anyway).
I have a workaround to log if the files are empty (To write to an output excel).What i need is to STOP/Terminate the WF when there is an empty file.
i have to do some calculation post the Join tool.My expectation was that if no records are passed by message tool then the Join will fail and the WF terminates.But sadly that is not the case.The message tool passes the header row and block the record.Due to this the Join tool will generate output (Left Out/Right Out) and the WF continues to execute.
Inside of the CReW macros there is a Blocking Test macro featured in this video.
You can use the blocking tool to make sure that there is data by inserting a COUNT ROWS tool (macro) after the input and APPENDING the "source count" to each record. Then use the blocking test to ERROR when the count = 0. After the blocking tool, you can put a select tool onto the canvas to remove the count field. When an error is encountered, you can configure the workflow to quit.
You can download the CReW macros here or navigate to chaosreignswithin.com .
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.