Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Condition for auto report

Borisham
8 - Asteroid

Hello,

 

The reports are sent automatically from the Gallery by the data that fed daily into the table.

If just some data has been received that day to the table, the report will be sent anyway (Which comes half correctly).

 

Is there a way I can control this automatically workflow by a condition like If count(*) < 5000 Then send alert message Else send the report) ?

 

Because I know just the roughly amount of the records that should be fed into the table(daily receive) I can't find a specific number of records that will tell us the report is corrected. 

 

I thought to provide a rough number (5000), but if you have another idea I would be happy to know. 6000 is the average amount but could be lower than that in some days.

 

Thanks for helping

 

2 REPLIES 2
RishiK
Alteryx
Alteryx

@Borisham you can do this in your workflow based on the record count that comes from the table. The screenshot below may help:

RishiK_0-1608637617100.png

 

pedrodrfaria
13 - Pulsar

Hi @Borisham 

 

I added below a workflow that represents how you can accomplish this. Where we are counting records, creating a conditional to see if it is above 5000 and giving you either a message or emailing the report based on the conditional being met. 

 

pedrodrfaria_0-1608639722534.png

 

 

Pedro.

Labels