Forum Discussion
DaX or Power Query for creating new tables
While what you've done is fine, one way to do it in the query editor:
1. Right click on one of your queries/tables and choose "Reference"
2. In that new query, select your Email column, right click and choose Remove Other Columns
3. Create a Reference query from your other table with email column
4. Do same as step 2 with it
5. Rename the Email column to exactly match (case sensitive) the one in step 2
6. Choose append and add the query from step 2
7. Remove Duplicates
8. Right click on the step 2 query and uncheck enable load
9. Name and load the combined email table
It's a lot of steps but they can be done quickly.
Pat
While what you've done is fine, one way to do it in the query editor:
1. Right click on one of your queries/tables and choose "Reference"
2. In that new query, select your Email column, right click and choose Remove Other Columns
3. Create a Reference query from your other table with email column
4. Do same as step 2 with it
5. Rename the Email column to exactly match (case sensitive) the one in step 2
6. Choose append and add the query from step 2
7. Remove Duplicates
8. Right click on the step 2 query and uncheck enable load
9. Name and load the combined email table
It's a lot of steps but they can be done quickly.
Pat