Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
9 years ago
Solved

Power Query Assistance

Hello community,   I need help with this:    Table 1 registers tasks of people for a specific job, but it registers only the current team:     Table 2 keeps track of historical allocated...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    I'm not sure if I understood your data model 100% but I used two columns for the Left Outer Join: fullJOB and Task

    The changed file is here

     

    After the I expanded the table and just selected the column 

     

    Rows in the base Table "Jobs" have not been duplicated ...

     

    After that I created a custom column Team", but as far as I understood your requirement it would also been sufficient to take Initial Team column

     

     

    Here is the result in the report

     

     

    Hope this helps

     

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

I'm not sure if I understood your data model 100% but I used two columns for the Left Outer Join: fullJOB and Task

The changed file is here

 

After the I expanded the table and just selected the column 

 

Rows in the base Table "Jobs" have not been duplicated ...

 

After that I created a custom column Team", but as far as I understood your requirement it would also been sufficient to take Initial Team column

 

 

Here is the result in the report

 

 

Hope this helps

 

Fcoatis's avatar
Fcoatis
Post Patron
9 years ago

Thank you TomMartens,

 

My rookie knowledge wasnt aware of the possibility to link 2 columns in the merge step. That was the ace in the hole. next step: Go Live.

 

Best regards.