Forum Discussion

pxg638's avatar
pxg638
Frequent Visitor
9 years ago
Solved

merging tables on two columns

Hi there,    First post, so apologies if this is super dumb - I was either searching for the wrong thing or being exceedingly dense in understanding what others had written! I have a large (1m row)...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    pxg638

     

    did you guys solve it with SQL after all?

     

    If so, could I ask you to accept a solution for this post, so others can benefit from it anyway?

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

pxg638 why dont you create a new column, ie a key based on the combination of  both the columns?

  • pxg638's avatar
    pxg638
    Frequent Visitor
    9 years ago

    So I can create [Unit]&[Date] in both tables, that is simple enough, how would I then utilise that to create the change in allocation between jobtypes? Wouldn't a join on the new column simply leave lots of gaps where it didn't key up?

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      9 years ago

      pxg638 ah ok, tell me a bit more about the change in allocation, its not clear to me from your post (i might be a bit slow this morning)

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi pxg638

         

        Could you provide column headers? I want to re-create your problem in Power BI to test a solution, I have in mind.

         

        Thanks in advance.

         

        Best

        Martin