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.

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

webportal

 

In Power BI Desktop, when using "Append Queries", if two tables have different number of columns, it will append all columns together and generate columns of blank values for the table with less columns. It's "CROSS" appending. If you want to do "INNER" appending. You have to copy Table2 and only keep 5 columns, then append with Table1.

 

Regards,

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

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

    In fact, it is quite simple.

    Thank you

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Can you elaborate how you did this in BI? Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Where is the solution?