- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Combine two tables with similar column headings together
Hello everyone,
I have various tables loaded in my Power Bi file. I am trying to merge two tables, sales and leases, into one since they have same column headings. Both have a 'Listing ID' column which contains unique values. I tried the 'merge' within PQ but all it does is give me additional columns from the second table. I tried append also but that somehow nullifies the listing IDs of the second table.
Is there a way that I can do this? I did combine the two files in excel but for the sake of ensuring data update, I would prefer to do it from within power bi.
I am pasting snippets of both files below, if that helps. There are hundreds of other columns extending to the right in each table.
Thanks in advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

sorry mate, didnt quite understand you. if you are referring that i match listing ID columns in each table with each other, i did that too (also renamed both so they are exactly the same).
Can you dumb down the explanation for me please?
Thanks again
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

PQ is case sensetive so "Listing ID" and "listing id" are not the same animals.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Great. Let me give it a shot.
Cheers

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-06-2024 10:24 AM | |||
09-27-2023 12:52 AM | |||
03-09-2024 08:01 AM | |||
Anonymous
| 01-16-2024 08:37 AM | ||
08-05-2024 11:49 AM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |