Replacement Team names

[Kamo]

Hi,
I'm calling about a new problem.
Everything is explained in the attached file
I thank you in advance for your support

Sincerely

 

[AliGW]

It can be done with just two queries if you add a line to the replacement table.

 

[Kamo]

Hi AliGW ,

Thank you for your solution, I hadn't thought of using the Merge command,
Thanks and have a nice day

 

[Kamo]

I think I've found how to adapt the code in my first file for 2 columns
Sincerely

 

[AliGW]

You're welcome.

 

[GraH - Guido]

Alternative, but seems @Kamo came up with something similar.

 

[Kamo]

Hi GraH - Guido,
Thank you
I like this shorter alternative and the List.Zip function
Sincerly

 

[GraH - Guido]

Thanks for the feedback. You could add the replacement list before the source step and buffer it. So you'd have 1 Query. Then in the replacement step you refer to the name of this first step.
Probably it can be made even shorter. But I die not have time to think on it.

 

[Kamo]

I think I know what you mean,
It would indeed be a bit easier to modify the Replacements table but your solution is already very good
Thanks