Power Query Merge or Append?

[PraRan]

Hi, I'm trying to combine 2 reports with inconsistent columns and column names into a single report. Is this possible in Power Query.
For example report 1 has the following columns

Fiscal Qtr

Fiscal Wk

BU

Segment

Rep Seg

Alloc

Territory

PFAM

Product Line

Material Key

Customer

Customer #

Size

Size Key

Inventory Unit

Inventory Vol

Inventory $

And report 2 has the following columns

Fiscal Qtr

Fiscal Wk

Bus Group

Segment

Segment Name

Alloc

Region

Group

Mapping

PFAM

Product Line

Material

Customer Name

Size

Mem Tech Hybrid Name

I want the merged report to have both unique columns from both reports and include all rows from both reports.

Is this possible with Power Query.
Thanks!

 

[sandy666]

did you try first

 

[PraRan]

I watched some videos, but those were only to append when columns were consistent or used the merge function in place of vlookup

 

[sandy666]

sure, could you post an example of expected result based on your post#1 ?

 

[PraRan]

I haven't actually tried it. What I saw in those videos is that merge adds a column and append adds rows.
While in merge you can do a full outer join to include and display all columns. But this method will create new columns for rows that cannot be found in the primary source.
Which helps in identifying rows that are not present in the primary source. As a result more operations need to be performed to cleanse the data and make it more compact to make columns more aligned so they don't appear 2X
I'm waiting for my team member to give me the file and start experimenting with it. I'll keep you posted on it.

 

[sandy666]

sure