Forum Discussion
PSan1979
Helper II
6 years agoNeed to create Bucket based on Group
Hi Experts, I have two tables (Table 1 and Table 2 in my data model and is joined by Surid). I want to vloop (if Surid from table 2 exist in Surid1 from Table1 then fetch SURID,Gender,Studying,fi...
PSan1979
Helper II
6 years agoIs It possible to create a separate table. and VLOOP Table2 from Table 1. if its matches then display value else blank
| ID | COL1 | COL 2 |
| SURID1 | XXX | 1 |
| SURID2 | 1 | XXX |
V-lianl-msft
Community Support
6 years agoHi PSan1979 ,
Unpivot then create a 1-* relationship with table2
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.