Hello,
I have been trying to generate email notification for the below use case, i have been unsuccessful so far, any help is truly appreciated.
Here is my use case:
This is a sample set
| Ecom_Order_Id | Net_Sales_Amt | full_net_sales_amt | net_sales_amt_diff |
| 351063 | 1497.53 | 1498.08 | -0.55 |
| 241329 | 88.88 | 89.38 | -0.5 |
| 59512 | 169.54 | 170.54 | -1 |
| 156987 | 0 | 129.93 | -129.93 |
| 165606 | 91.02 | 93.02 | -2 |
| 148215 | 33.01 | 34.01 | -1 |
The sample output is from a database, it is not a file output, i connected to teradata and wrote my sql query to generate this sample output.
I want to be able to generate the output from terdata via alteryx and email this output as an attachment.
1. I am able to connect teradata to alteryx and generate the result/output
2. i connected the table tool to the input tool to pull the data to a table tool
3. I then connected the table tool to layout tool to combine all the records together.
4. I then connected the layout tool and chose combine all the records from the drop down of layout tool
5. When i choose combine all the records and run the workflow, the layout tool does not return results or output
6. i had to choose each individual records and run the workflow and this returned the results or the output data
7. I connected the email tool to the layout tool since it returned output data.
8. I am getting multiple emails, if my output has 10 rows, i am getting 10 emails, each email for each row.
9. How do i set the tool or the workflow to email the entire output in just one email?
10. I have tried various options and i have been unsuccessful so far.
11. I am facing this issue only if the output is coming out of a database, if i try to email a file from my local machine, it is working just fine and i am getting the email as needed, i think the problem is when the output is from a database.
Any help is truly appreciated.
Regards,
Harsha Rappan
