Hi @nileshvk :
I assume there are two tables:
ClearCollect(tbl2,{id:1,Col2:1,tbl1Id:1},{id:2,Col2:2,tbl1Id:2},{id:3,Col2:2,tbl1Id:3},{id:4,Col2:3,tbl1Id:4},{id:5,Col2:3,tbl1Id:5});
ClearCollect(tbl1,{id:1,Col1:"A"},{id:2,Col1:"B"},{id:3,Col1:"C"},{id:4,Col1:"D"},{id:5,Col1:"E"})
Please use this formula to get the result:
RenameColumns(
Distinct(
Filter(
tbl1,
id in Filter(
tbl2,
Col2 = 2
).id
),
Col1
),
"Result",
"Col1"
)
Best Regards,
Bof
