Forum Discussion

Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost 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

     

Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost Patron
9 years ago

Hey you,

 

I used fullJOB for the join and I didnt expect duplicates.

 

Thank you for your time.

TomMartens's avatar
TomMartens
Icon for Super User rankSuper 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
    Icon for Post Patron rankPost 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.