Conditional join for Dynamic Columns

[Lokeshwar]

Hi,

I need to replace the values in Left Table containing Dynamic columns with a Right Mapping Table only when the column values in the Mapping table is Not NULL. In case value of a column in Right Mapping table is NULL, the Left Table Dynamic column values remain as it is (not replaced by right table). Below is an example -

Left Table with Dynamic Date columns -

Pri Gci No_Client	06_01_2019	07_01_2019	08_01_2019	09_01_2019	10_01_2019	11_01_2019	12_01_2019
998652887	1234			834179.26
335538317	784212.81	313886.49	14195.3	27924.89	14195.3	13998.48	34920.69

Right Mapping Table -

Pri Gci No_Client	06_01_2019	07_01_2019	09_01_2019
998652887			11801.03
335538317	164905	14195

Desired Output -

Pri Gci No_Client	06_01_2019	07_01_2019	08_01_2019	09_01_2019	10_01_2019	11_01_2019	12_01_2019
998652887	1234			11801.03
335538317	164905	14195	14195.3	27924.89	14195.3	13998.48	34920.69

Thank you

Lokeshwar

[atcodedog05 · Accepted solution]

Hi @Lokeshwar 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Qiu · Accepted solution]

@Lokeshwar 
A bit different approach with @atcodedog05 . Hope you like it as well.

[atcodedog05]

Happy to help 🙂 @Lokeshwar 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂

[Qiu]

@Lokeshwar 
Thanks for the accept mark.

[Lokeshwar]

Thank you for your quick response.