Custom Column help

[Anonymous]

Hello i am having trouble adding a custom column to my query, basically what i want to do is the next, i have 3 tables LAYOUT, CONTRATOS and CCunicos the one I am working on is LAYOUT

What i want to do in my new column is to get information from one table or another depending on the value of the column [ID RS] from LAYOUT, if its 39, 41 or 46 i need to get the corresponding [Contrato] from CCunicos  to those ids

if the value is different i need to get the corresponding [CC] from CONTRATOS using [ID RS] and [ID LOC] as Keys 

note:  [ID RS] and [ID LOC] are the original values from LAYOUT

i have tried using the Table.SelectRow function but my code didnt work

Leo

[v-frfei-msft]

Hi @Anonymous ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[Anonymous]

the problem is this is confidential info

[edhans]

Well, you can PM me a link to it vs posting in the forum. I'm genuinly curious as to what the issue is.

If you cannot do that, I'm not sure what else I can do.

[Anonymous]

done i posted some sample data on the original post

[edhans]

You want a conditional merge. I responded to your request here about that. Please continue in that thread with some sample data if the code I provided didn't work for you.