Creating New Table from fields from 2 existing tables

[SteveBrou]

I would like to create a new table using particular columns from an existing table 1 and an existing table 2. Some of these columns are the same fields in both table 1 and table 2 (e.g. First Name, Last Name, Target Start Date, and a few others). There are some columns in table 2 that are not contained in table 1. I would like to add these columns to the newly created table. The expected result would be that the rows brought over from table 2 would have information in this column and the rows already populated in the new table from table 1 would be blank. In addition, any rows that I bring over to the new table from table 1, I would like to filter based on a status field in table 1. Any rows that I bring over to the newly created table from table 2 I would also like to filter based on a status field contained in table 2. What is the best way for me to accomplish the above? Thanks in advance!!

[harshnathani]

Hi @SteveBrou ,

Please share sample of Table1, Table2 and expected output in text (not an image pls)

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

HN

[SteveBrou]

Table 1                                  Table 2

Job Title                                 Job Title

LCAT                                      First Name

First Name                             Last Name

Last Name                             Target Start Date

Target Start Date                   Subcontractor Name

Expected Output (New Table)

Job Title

FIrst Name

Last Name

Target Start Date

Subcontractor Name

Since the subcontractor name field only exists in table 2, the only rows that would have a value in subcontractor name column are those rows from table 2. The rows from table 1 would have no value in that column.

Thanks!