Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Compare values ​​and enter data

Hello....   I have two tables   ----------------TABLE ASISTENCIAS------------------------ ID        NAME               PARTNER                    EMAIL 6          PEDRO              MICROSOFT  ...
Need Help
BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Anonymous ,

 

1) In Power Query, select your Reports table then go to the Home tab > Merge Queries.

2) When the dialog opens, select the [ID] column from the top preview window.

3) From the dropdown list near the bottom preview window, select your Attendance table.

4) In the bottom preview window, select the [ASISTENCIA] column.

5) Near the bottom of the dialog, make sure the 'Join Kind' dropdown shows LEFT OUTER.

6) Hit OK to merge, then use the button at the top-right of your new column which looks like two arrows bending away from each other to choose the columns you want to expand.

 

Pete