Carl,
Attached is one of the files used to perform a full outer join between prior and current.
Steps taken include: explicitly naming each table, creating power queries for each named table and then loading each as connection only.
Used the Merge feature to combine the two tables, with the join option of full outer join.
Before merging can complete, you need to specify the columns in each table to join. After combining the tables, you still need to expand the second table (the right-side table).
Tom
Attachments:
You must be
logged in to view attached files.