Forum Discussion

webportal's avatar
webportal
Impactful 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
Impactful 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
    Microsoft 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
      Impactful 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.

  • kcantor's avatar
    kcantor
    Community 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.