Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Block until done + Test to perform checking before output file

HMSUM
7 - Meteor

What I am trying to do is 

 

1. Load dataset

2. Split to 2 roads - using "block until done"

3. Check amount of record - using "test"

3a. if test is success, continue export file

3b. If test fail, pop error and can exporting file

 

However, in my case, even test is fail and I set "cancel running workflow on error" to true, the folder is still output.

 

Attached screenshot and workflow for reference, anyone can suggest how can achieve what I expected correctly?

 

screencap.PNG

6 REPLIES 6
AkimasaKajitani
17 - Castor
17 - Castor

Hi @HMSUM 

 

Is 3b correctly "stop export file"?

If then, you can use Message tool.

 

AkimasaKajitani_0-1606282183739.png

 

AkimasaKajitani_1-1606282198562.png

 

Message tool can stop the data if the conditions are matched.

HMSUM
7 - Meteor

No, it still export file, as you can see in the log section, the file is still exported

AkimasaKajitani
17 - Castor
17 - Castor

My result shows that it doesn't export the file.

 

AkimasaKajitani_1-1606283195819.png

 

Did you use my uploaded workflow?

 

HMSUM
7 - Meteor

Thx for solution for record counting, how about if I need to use other testing conditon, let say checking incoming record after joining match number of record before join.

HMSUM_0-1606285342882.png

 

 

AkimasaKajitani
17 - Castor
17 - Castor

For example, to check if there are "2" in the incoming data, it is possible to create the below workflow.

 

The basic idea is to build the check logic, combine the results with the Append Fields tool and detect them with the Message tool.

AkimasaKajitani_0-1606286400423.pngAkimasaKajitani_1-1606286438641.png

 

AkimasaKajitani_2-1606286464380.png

 

saltyplanet
7 - Meteor

Hi , I tried your example, it still exported the file even with the error message below ..

 

saltyplanet_0-1654887175853.png

 

Labels