Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 3 tables in my data model that contain substantially the same data. Each of the three tables represents a subset of the same information dealing with timeslips entries.
Table 1 contains timeslip entries in colums designated: UniqueID, date-of-service, Timekeeper, Time Worked, etc. (Some of these columns are unique to Table 1 and are not contained in Tables 2 and 3.)
Table 2 contains entries from the same timeslip with many columns identical to those in Table 1 (including UniqueID, which is common to all three tables), but Table 2 also contains columns that are not identical to columns in Tables 1 or 3, e.g., : billing status, bill value, etc.
Table 3 again contains entries from the same timeslip as Tables 1 and 2 with many columns that are indentical to those in Tables 1 and 2, but also contains unique columns that are not identical to those in either Tables 1 or 2, e.g., Work Description Text.
I have tried appending these 3 tables into a new table, but the new table now contains 3 rows for each timeslip and I am lost as to how to combine the rows based on the UniqueID so that I am left with only 1 row per timeslip.
Advice greatly appreciated.
Solved! Go to Solution.
Hi,
You should not be appending but Merging (side by side) those 3 Tables.
Hi,
You should not be appending but Merging (side by side) those 3 Tables.
Thanks, Ashish. You pointed me in the right direction.
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |