community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

process based on input

Meteor

Suppose if I have any instances then those will be showed in the table accordingly and would be emailed. 

But what if I do not have any data  (no rows) and i want to send "There are no Instances" in  the email trough report text tool?

Alteryx Certified Partner
Alteryx Certified Partner

Take a count records, prior to building your report, and append it to your datastream.

 

Then build your table element, but on the same stream, after, create your text element.

 

Then use a formula to acknowledge which element to include in the email...

 

The field would have to be 'Blob' in type.

 

If Count = 0 then [tableelement] else [textelement] endif

 

Then reference this field in your email.

 

Ben

 

 

Alteryx Certified Partner
Alteryx Certified Partner

I've attached an example of how this would work; the sample tool I have used to set the number of records to 0, if you make this greater than 0, or remove it entirely, then you will get the behaviour as if there were data.

 

Ben

Meteor

Hi Ben,

Dont know why i am getting this error. Do you know why this error occurs?

Alteryx Certified Partner
Alteryx Certified Partner

When you say error you mean that the field is NULL?

 

 

Meteor

Hi Ben,

Iv'e kept type "BLOB" and the preview tool shows null.

Capture.png

Labels