Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance during the next 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

Can we get count of Inserts and Updates happened in Output Data tool in a mail

Highlighted
Meteor

Hi All,

 

I need to get Count of inserted and updated records which are happened in a Output data tool via mail. is that possible ?

Highlighted
Fireball

Just to clarify, are you working on trying to get an email that tells you how many records are inserted or updated after a run?

Highlighted
Meteor

hi @Paulteryx

 

yes correct, want a mail with counts of inserts and updates happened a table, while using Output data tool.

Highlighted
Fireball

Without knowing exactly how your data is structured, one way I can think to do this would be to join the records in your update set to the existing records in your database, then you can flag those that joined as updated and those that don't join as new. Take those values and use a Summarize to group by those flags and do a count. From here you would go to a Report Table Tool and then to an Email tool. This will generate an email with the table including a count of the updated records and the additional records.

Labels