Open Error on Insert

[BuckeyeJane]

Getting an error in the following workflow because the join does not have any columns.  How do I change the workflow to only insert records to the Database when there are records from the the join?  This may sound like a crazy easy question but  I'm still learning how Alteryx works and thinks so your help is greatly appreciated.  :)

 

[Thableaus · Accepted solution]

Hi @BuckeyeJane 

I'm not sure how your Output is configured, but you could try to add a Message Tool before the Output Data tool.

Set "Before Rows Where Expression is True" , add the Formula [_RecordNumber_] = 0 and Message Type to "Error - And Stop Passing Records Through This Tool".

Let me know if it works. I think it depends a lot if you have Pre-SQL Statements and Post-SQL Statements as well.

Cheers,

[BuckeyeJane]

Thank you, 

For some reason it didn't like the  [_RecordNumber_] = 0 portion.  But added a record count tool prior to the Message tool and used the count field.  And it stopped trying to write a records.  But, it does include an additional message When it runs the error message is shown in the messages and its registered as  a critical error,  

So far it looks to be the answer and working well. The only testing i need to complete is having it run on a schedule. 

Thank you Very much for your help.