Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear All,
I have the following situation:
Table 1
Col 1 Col 2 Col 3
Name 1 Data XX Data XY
Name 2 Data 11 Data 12
Name 1 Data XA Data YY
....
Table 2
Col 1 Col 2
Name 1 INFO 1
Name 2 INFO 2
....
I would like to create another Col in table 1 with information of Col 2 of Table 2 considering the correlation of Colmns 1 into the two tables, that is:
Final Result
Col 1 Col 2 Col 3 NEW Col
Name 1 Data XX Data XY INFO 1
Name 2 Data 11 Data 12 INFO 2
Name 1 Data XA Data YY INFO 1
....
Thank you!!!!
LD
Solved! Go to Solution.
Hi @LD ,
Create a relationship.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @LD ,
Create a relationship.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |