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.

Email if table is not existed

Borisham
8 - Asteroid

Hello,

 

I have a workflow that relies on a temp table (Drop / create daily).

 

I would like to receive an email on when this table is not created / not exist (scheduled task).

 

How could I achieve it ?

 

 

Thanks

 

 

1 REPLY 1
AngelosPachis
16 - Nebula

Hi @Borisham ,

 

One way would be to use a "Count Records" tool after your table tool. If the table is not there, that tool will return the value of zero, else if it is there it will return the value of one.

 

So then you can use a filter tool, checking if the count is 0 and out of the True output anchor you can stick an e-mail tool to send an email.

 

Hopefully that makes sense. Let me know if you any questions.

 

Cheers,

 

Angelos

Labels