Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am trying to combine two tables that have two coloumns each. We need to combine these tables based on characteristics of two coloumns of Table A with one coloumn of Table B - As shown in the image below. Any help in this matter would be greatly appreciated.
Thanks,
Jacob.
Based on your data, is it simply that you wish to join each row on the Table A with the rows on Table B based on them having the same Industry?
First things you will need to do is ensure you have a constant value for each industry. You can either do a find/replace or make a new column to achieve this.
After that is done, you can use the Merge operation to bring the tables together. This is all being done within Edit Queries.
Some Questions to answer: In scenarioes where you have more than M rows in an industry in Table A and N rows for the same industry in Table B, are you expecting a result that is M time N rows?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |