Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have two tables, one containing a list of Accounts and the other containing a list of Transactions.
Accounts:
AccountID | Name |
0014J00000TY6bJQAT | Joes Sub Shop |
0014J00000YMuK1QAL | Bill Boots Barn |
0014J00000YMuh8QAD | Johns Jumpsuits |
0014J00000TYcRxQAL | Sallys Safes |
0014J00000TYdxXQAT | Toms Turkeys |
0014J00000TYeXWQA1 | Larrys Leggings |
0014J00000TYep2QAD | Dons Donuts |
0014J00000TYfisQAD | Paulas Pencils |
0014J00000TYGxPQAX | Ethans Elephants |
0014J00000TXwnyQAD | Helens Helmets |
0014J00000TXrpVQAT | Walters Wafers |
Transactions:
TransID | AccountID | ReferringAccount |
100010101 | 0014J00000TY6bJQAT | 0014J00000TYGxPQAX |
100010102 | 0014J00000YMuK1QAL | 0014J00000TXwnyQAD |
100010103 | 0014J00000YMuh8QAD | 0014J00000TXrpVQAT |
100010104 | 0014J00000TYcRxQAL | |
100010105 | 0014J00000TYdxXQAT | |
100010106 | 0014J00000TYeXWQA1 | |
100010107 | 0014J00000TYep2QAD | |
100010108 | 0014J00000TYfisQAD |
In the data view, I have created a new column in the Transactions table using the following:
TransID | AccountID | ReferringAccount | ReferringAccountName |
100010104 | 0014J00000TYcRxQAL | ||
100010105 | 0014J00000TYdxXQAT | ||
100010107 | 0014J00000TYep2QAD | ||
100010106 | 0014J00000TYeXWQA1 | ||
100010108 | 0014J00000TYfisQAD | ||
100010103 | 0014J00000YMuh8QAD | 0014J00000TXrpVQAT | None |
100010102 | 0014J00000YMuK1QAL | 0014J00000TXwnyQAD | None |
100010101 | 0014J00000TY6bJQAT | 0014J00000TYGxPQAX | None |
I expected the table visualization to contain
TransID | AccountID | ReferringAccount | ReferringAccountName |
100010104 | 0014J00000TYcRxQAL | None | |
100010105 | 0014J00000TYdxXQAT | None | |
100010107 | 0014J00000TYep2QAD | None | |
100010106 | 0014J00000TYeXWQA1 | None | |
100010108 | 0014J00000TYfisQAD | None | |
100010103 | 0014J00000YMuh8QAD | 0014J00000TXrpVQAT | Walters Wafers |
100010102 | 0014J00000YMuK1QAL | 0014J00000TXwnyQAD | Helens Helmets |
100010101 | 0014J00000TY6bJQAT | 0014J00000TYGxPQAX | Ethans Elephants |
What am I doing wrong?
Thanks
Solved! Go to Solution.
@Anonymous , I think it should
@Anonymous , I think it should
Thanks! The first suggestion worked on the sample I provided (except those that didn't have a match were left blank instead of saying "none"). However, when I applied it to my real world case, it did not work. Good news though, the second suggestion worked both times. Thank you for the quick reply and suggestion.
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |