Retrieving a record count (counter) and sending email for every record count change

Question

Hi there.

Fairly new user here.

I would like to send myself an email from my WF if my record count increases by 1 or more. Currently, I have my data in an Alteryx table using the table tool. I have my email tool setup also. I'm not quite sure how to tell it

IF [row_count] = [row_count] + n

THEN send me an email

ELSE don't send me an email

Is there a row counter of some sort I could use? Screenshot attached.

Thanks, SB

Capture.PNG

AkimasaKajitani · Answer

Hi @Lady_B ,

When the first running, you need to make Counter.yxdb by using another workflow.

Or you want to use the same workflow at first running, you can do it by using batch macro(It is a little complex).

Batch macro

Mail_increase_sample_AK2_for_community.yxzp

Lady_B · Answer

I think I figured it out. I have to run it so that the output tool creates the counter.yxdb. Now I have to wait to see if this works.

It would be a bonus if I could get the data table to only grab the newly added records instead of all the records. Any idea how to do this.

Lady_B · Answer

Thank you. I am trying this now. I do have one question.

The "read previous count" input tool, how do I create the counter.yxdb? Is that created at runtime?