Adding a column from one table based on a value in a second table

Power Query M Code Showcase
1

I have two tables.

One contains all of the transactions that I need, but there is no common way within the table to bring them together. ie account number.

Some transactions have one and others don’t.

However the transactions that do not have an account number, do have another reference (Job Number) that exists on another table with an account number.

My idea is to add the account number by looking up the job number in the other table.

I am pretty sure it can be done, but not sure of the syntax.

I know it can be done in DAX, but would prefer to do it in Power Query.

Thank you.

2

Hi,

Attempt a left join with the second table using the Job Number to obtain an account number. Next, create a second column where you check if there is an account in the first table; if it exists, use it; if not, use the joined account from the second table. In the end, you will have one column with populated accounts.