Append subset of columns

IanR
Posts: 11
Joined: Wed Aug 09, 2017 11:30 pm

Append subset of columns

Postby IanR » Wed Nov 22, 2017 9:36 pm

Is there a way of appending a subset of the columns from one query into another? As far as I can see the Append function only really works when the two queries have the same number of columns. When this isn't the case, for example when the table that is being appended from has more columns than the table that is being appended to, new columns are created with null values for rows in the appended to table. Corresponding columns also have to be in the same order in each query.

Neither of these conditions fits my data. What I would like to do is select the columns that I would like to append from and select the columns that they are appended to, with no requirement that all columns from the append from table have to be used. Can this be done?

Thanks
Ian

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest