How to consolidate rows and send a single email

Secondly, if you do not use summarize then you will get 10 rows of a single email id another thing you can use is a unique tool based on email it will give you a single email only.

Is it possible for you to attach your workflow and the desired result that you are looking for?

Thanks!

All comments

philipmannering

Reduce the number of rows. You can do this with the Summarize Tool or Unique Tool. But the Basic Table (if no Group By) should consolidate the rows down to one single record...

cvalteryx

PhilipMannering - But, I need to get all rows in one single email as a table.

philipmannering

What's in each row? Can you send a screenshot of what the data looks like? A Basic Table reporting tool should consolidate all your records. Multiple tables can be consolidated down to one row with the Layout Tool.

binu_acs

@cvalteryx as @PhilipMannering suggest use the sample/unique/summarise tool. Attaching a sample email

Email_03_06.yxmd

grazitti_sapna

Hi @cvalteryx, can you try this?

Thanks!

cvalteryx_workflow.yxmd

cvalteryx

PhilipMannering - Consider the attached screenshot as my sample data. I want to send email with all 3 columns and all the rows as a table in a single email. But, I receive multiple emails for row of the table.

EmailConsolidate_SampleData.JPG

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703