Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
106 | |
88 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |