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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |