Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to send notification mail to user with Table details

kritikamish99
6 - Meteoroid

Hello ,
i have two table 

Table 1: 

DaysStatusProduct FamilyMarket
5LateABCGermany
13LateABCTaiwan
14LateXYATaiwan
21Late

E

 

 

 

 

 

 

 

 

 

AKS

Argentina
22LateLKSFTaiwan
26LateOLKATaiwan
28LatePQOBrazil

 

Table 2: This list is having country specific Lead managers

CountryUser
ArgentinaEmpl1
ArgentinaEmpl9
ArgentinaEmpl8
ArgentinaEmpl13
BrazilEmpl9
BrazilEmpl10
BrazilEmpl12
BrazilEmpl6
BrazilEmpl7
BrazilEmpl8
BrazilEmpl7
TaiwanEmpl11
Taiwan

Empl1

 

I need to send Notification mail to All manager when country in both table matched
For example :

Taiwan is present in both the table then I need to send only one notification to Emp1 and Empl11 with 

Table as attachment with table content 

22LateLSKFTaiwan
26LateOLKATaiwan


So far i tried doing something which is sending individual entry to each manager (attachment of flow )

 

 



 

 

5 REPLIES 5
Raj
16 - Nebula

@kritikamish99 
but your first table had 4 values for Taiwan?

kritikamish99
6 - Meteoroid

@Raj Oh sorry My bad .

yes it should output all 4 value from Taiwan country 

how I need to do this flow 

Raj
16 - Nebula

@kritikamish99 
Find the workflow attached
Mark done if solved.

kritikamish99
6 - Meteoroid

@Raj ,
This has created the group for the table . Partially worked for me .

But my major concern was to send it as mail to Manager which is mentioned in table 2 as Emp1 Emp2.. so on for specific country from table 2 by attaching the table 1 details where market and country are matching, and days is less than 30.

So mail will have content says : " Dear Manager the following product is delayed by 30 days "
this mail will have attachment of table which has product less 30days and market is matching. 

This should be send mail as attachment . Since i am running in server it comes out as link rather attachment 

Raj
16 - Nebula

@kritikamish99 
find the updated workflow attached
and the snip of result generated from it

mark done if solved.

Labels