Put conditional column in a function based on conditions

[jaryszek]

Hello,

i have 3 tables:

tableKey:

and TableDef:

and TableMap:

as you can see TableDef and TableMap has 2 key columns: Key1 and Key2.

Wha i want to write function which:

1) will join 2 the same tables by keys (Key and Key2). (so will check what we have in TableKeys and use it properly).

2) Generete the list which exludes Keys and using only all other columns

3) expand all other columns from joined table

I want to automate these steps using function.

Link:

https://drive.google.com/file/d/1xzz4M2yPz6J2SndtXdt0_ubCCxRR9QCa/view?usp=sharing

Can anybody help?

Thank you in advance,
Best,
Jacek

[v-jingzhang]

Hi @jaryszek 

Can you provide the expected output in table format with the sample data? That would help us understand your requirement better. Currently I'm a little confused about what the expected result should be like.

Regards,
Community Support Team _ Jing