Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How do I find information in a table where the data can be found in three different columns of a different table?
Example:
Table A [Column A]
Return for 'Table A [Column A]' the code z001, which can be in any of the columns of 'Table B':
Table B [Column A]
z002
z003
z001
Table B [Column B]
z004
z005
z007
Table B [Column C]
z008
z001
z009
Solved! Go to Solution.
Your question is unclear. If you want a specific code... why would you want to look it up if you already know it? Secondly, you should consolidate the tables into one. Then you won't have problems.
Your question is unclear. If you want a specific code... why would you want to look it up if you already know it? Secondly, you should consolidate the tables into one. Then you won't have problems.
User | Count |
---|---|
50 | |
25 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
21 |