Expertise needed PLEASE. Merging tables same data type, yet different header names

[tbobolz]

I have not had much experience with merge and append and from my understanding, what I'd like to achieve is somewhat different then the merge or apend function. 

I have two table from different sources/companies; however, the data format is the same, row value would be unique, but headers are named differently. Both are imported via a a schedule gateway connection. 

Table one, which is already established and has an extensive reporting packed built around it, list surgeries with the say the following fields:   Loaction, Surgeon, Charges, Date.

Table two list the same fileds but named differently:         Entity, Physician.Surgeon, Amount, Date.  

Patient visits are unique, so no worries about one to many, or many to many relationships.

Is it possible to join/merge these two tables, and establish a new single table with unique header names? My alternative is to manually do it then load. I'm trying to automate the entire process and avoid that.

Thanks for any advice you can offer.

[Anonymous · Accepted solution]

HI @tbobolz ,

If your tables have same data structures, you can consider using Table.Combine function to merge two tables.

let
    Source1 = xxxx,
    Source2 = xxxx,
    merged= Table.Combine({Source1,Source2})
in
    merged

Regards,

Xiaoxin Sheng

[TomMartens]

Hey @tbobolz ,

due to the fact that a lot of reports are build based on the names of table A,

I would recommend the following:

1. Load Table A
2. Load Table B
3. Rename the columns of Table B to the names of the Table A
4. Append Table B to Table A

The renaming has to be done just once, even after publishing the report to the service it will work.

Hopefully this provides you with some ideas.

Regards,

Tom