Append operation for tables that get new columns

[Maria9292]

Hi everyone,  I want to append 2 almost identical tables into a new table. Both tables are constantly updated and get new columns that will not have the same names but may or may not contain similar data.  My question is will these new columns appear automatically in the new table that is a result of the Append operation? If so, when harmonize their names, will they merge into 1 column? If not, please help me with how to work with tables that need to be "appended" but also get new columns? Thank you! Maria

[harshnathani · Accepted solution]

Hi @Maria9292 ,

You just need to make sure all worksheets you want to combine share the same structure, then, place the new generated Excel file into the same folder, refresh the existing query  in Power BI desktop, the new data will be appended automatically.

For more Details

https://community.powerbi.com/t5/Desktop/Get-data-from-folder-and-append/td-p/526274

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Maria9292]

Thank you @harshnathani for your reply!

Seems like my situation is a different from the tread you copied. 

I have 2 queries, like this:

A	B	C
1	...	...
2	...	...
3	...	...

and

A	B	C
4	...	...
5	...	...
6	...	...

I append them and make a new table.

Every week a column is added to each of them:

A	B	C	D
1	...	...	...
2	...	...	...
3	...	...	...

and

A	B	C	Z
4	...	...	...
5	...	...	...
6	...	...	...

Will columns D and Z appear in a new table? 

Also, if columns D and Z had similar headers, would they appear in the new table as one column?

Thanks!

Maria

[harshnathani]

Hi @Maria9292 ,

Yes, it will if you have column D and Z as same headers.

Append works at the background as UNION ALL. 

For more details

https://www.youtube.com/watch?v=qXH4WjCykLc

Regards,

Harsh Nathani