Forum Discussion

SP3007's avatar
SP3007
Frequent Visitor
2 years ago
Solved

Power Query Lookup to another table

Hello, I need some help please!   I need to add a new column to my table. It needs to bring back a value by looking up a column against another table. ie - column it needs to look upto is: CCA1 T...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi SP3007 

    You can change the code to the following.

    = Table.AddColumn(#"5 - Added CCA1 Column", "OrgStructServiceID", each List.Min(Table.SelectRows(Helper_CCA1_Service,(x)=>x[CCA1]=[CCA1])[OrgStructServID]))

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi SP3007 

You can change the code to the following.

= Table.AddColumn(#"5 - Added CCA1 Column", "OrgStructServiceID", each List.Min(Table.SelectRows(Helper_CCA1_Service,(x)=>x[CCA1]=[CCA1])[OrgStructServID]))

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

SP3007's avatar
SP3007
Frequent Visitor
2 years ago

Thanks for this...its now coming back as null rather than error so one step closer!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi SP3007 

    Can you send a little bit of the sample data in the two tables, because if the data IDs in the two tables are the same, it should not return a null value

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • SP3007's avatar
      SP3007
      Frequent Visitor
      2 years ago

      Your solution worked! Thank you. My data was wrong.

       

      Thank you