Email Address

[Grail030510]

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	Email	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

[simonaubert_bd]

Hello @Grail030510 

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

Best regards,

Simon

[CPSlater · Accepted solution]

Example of what Simon mentioned for you.