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.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels