How to consolidate rows and send a single email

[cvalteryx]

Hi All,

I have a Select tool -> Basic Table -> Email.

Problem:

If I have 10 rows, I get 10 emails for each row formatted as a table.

But, I need to get 1 email consolidating all the rows.

(1 email with all 10 rows)

It would be very grateful, if someone provides any solution.

The workflow screenshot has been attached.

TIA

[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.

[binuacs]

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

[grazitti_sapna · Accepted solution]

Hi @cvalteryx, can you try this?

Thanks!

[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.

[grazitti_sapna]

@cvalteryx, did you try my approach?

Thanks!

[cvalteryx]

@grazitti_sapna - Yes, I tried and it worked for text input. But, what if I have batch macro and I don't want to summarize field1 ?

Thanks!

[grazitti_sapna · Accepted solution]

@cvalteryx, even if you have the batch macro in that case still this will work because these steps can be used outside the macro.

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!