Forum Discussion

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
9 years ago
Solved

Append two tables with different sizes

I have table one with 5 columns and table two with 7 columns. How can I append them into a new table with only the common columns (that is, the columns with common names)? I tried all sorts of "App...
Need Help
  • webportal's avatar
    webportal
    9 years ago

    Thanks, I've figured out how appending works on Power BI desktop.

    In fact, it is quite simple.

    Thank you

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
9 years ago

Sean

Thanks, but I think I need to append and not merge. It seems the solution would be to harmonize the column names for both tables in the editor and then all columns will show in the appended table.

Then, I'll remove the ones I don't need.

Thanks anyway.

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
9 years ago

webportal

Create blank columns in the table with only 5 columns to match the table with 7 columns. Append the queries then remove the unnecessary columns.

Just make sure the columns all have exactly the same column name and data type.