Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Email Address

Grail030510
7 - Meteor
‎03-05-2024 06:44 AM

Good Day,

 

I would like your help or opinion regarding what is the best solution for this problem, I want the Email_manager field to be filled up with the data coming from the email field (their personal Email address.

 

 

ID_NONameEmailMangerEmail_manager
101DukeDuke_03@google.comHawk Hawk_01@yahoo.com
102FalconFalcon_15@yahoo.comDukeDuke_03@google.com
103HawkHawk_01@yahoo.comFlagg 
104BeachHeadBeachHead_abc@google.comDuke 
105BazookaBazok14@gmail.comDuke 
106Recondorecon_045@gmail.comBeachHead 
107AlpinePine001@yahoo.comFalcon 
108FlaggFlagg03@Gmail.comFlagg 

 

Thanks In advance

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
simonaubert_bd
13 - Pulsar
‎03-05-2024 06:46 AM

Hello @Grail030510 

You can simply join your table to itself with manager=Name as key of the left join.

Best regards,

Simon

Reply
0 Likes
CPSlater
6 - Meteoroid
‎03-05-2024 09:24 AM

Example of what Simon mentioned for you.

Query response.yxmd
Reply
0 Likes
go to user group event calendar
Labels