Email sent out multiple times

[Ylin0615]

Hi,

I am creating a process to check the inputted file based on different criteria and at the end, gather all results in one file and email the file to users to take actions.

I was able to find solutions in the community to add a logic that only output the file when there's records. It seems worked, except the email will be sent out multiple times. it looks like depending on how many records in the file... Would anyone be able to help? Thanks!

Betty

[Yoshiro_Fujimori]

Hi @Ylin0615 ,

Please check the data at input anchor of Email tool.

I understand Email tool sends one mail per one row.

So if you see multiple emails, I guess there are multiple rows.

In that case, you may want to reduce the rows using Summary or Unique tool.

Just a guess, but I hope this may help.

[Ylin0615]

Hi Yoshiro,

Thanks for reply. Sorry that I am new to Alteryx so I don't know how Alteryx behave, sometimes is not as straightforward as I think. 

After you point out that "Email tool sends one mail per one row". I was able to resolve my previous issue but now I have another issue on the format of the email body.

===============================================================================================================

I can see the email body repeat the column 4 times because I have total 4 rows to (out of 2 projects) to output.

However, I would like them to be in one table and no repeats. So, the email body should only have one table with 4 rows.

The issue started after I add the email list before the email sent, here's how I set up the flow:

Thanks,

Betty

[Ylin0615]

Hi Yoshiro,

Sorry, I just realized the issue occurs already at the base table step. I think it is because I set up a group by with project...

At a point, I did get the result I am looking for but I guess by adding more features, I break it again...

Here's the current workflow.

Here's the ideal result.

This workflow is to review files based on set logic and collects the records that didn't pass the logic test and sent out to my team for review.

1. There 2 input files, one per project

2. the email body will combine both project's output in a table and add a text message above the table as showing 

3. use an excel file to control the distribution list

Would you be able help me debug my workflow?

Thank you!

Betty

[Yoshiro_Fujimori]

Hi @Ylin0615 ,

From the screenshot, I can just guess and I'm not sure, but I see you "Append Fields" tool for Layout tool and Input Data tool.

Append Fields duplicates the record as its nature.

If you use the excel file to provide the recipient address for Email tool, it would be better to use Join tool or Find Replace tool.