SOLVED
Email Address
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Grail030510
8 - Asteroid
‎03-05-2024
06:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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_NO | Name | Manger | Email_manager | |
101 | Duke | Duke_03@google.com | Hawk | Hawk_01@yahoo.com |
102 | Falcon | Falcon_15@yahoo.com | Duke | Duke_03@google.com |
103 | Hawk | Hawk_01@yahoo.com | Flagg | |
104 | BeachHead | BeachHead_abc@google.com | Duke | |
105 | Bazooka | Bazok14@gmail.com | Duke | |
106 | Recondo | recon_045@gmail.com | BeachHead | |
107 | Alpine | Pine001@yahoo.com | Falcon | |
108 | Flagg | Flagg03@Gmail.com | Flagg |
Thanks In advance
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
2 REPLIES 2
simonaubert_bd
13 - Pulsar
‎03-05-2024
06:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @Grail030510
You can simply join your table to itself with manager=Name as key of the left join.
Best regards,
Simon
CPSlater
6 - Meteoroid
‎03-05-2024
09:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)