Forum Discussion

IAM's avatar
IAM
Helper III
4 years ago
Solved

Power Query LookUp in another table

Hi all,   I have found so many (solved) posts, but I haven't managed to translate it to my situation, so I hope someone will help me.   In table IW38 I want to add a column M_Planner   That new...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi IAM ,

    You can add a custom column as below in the table IW38 in Power Query Editor, please find the details in the attachment.

    = Table.AddColumn(#"Changed Type", "M_Planner", each PlGrp[Planner]{List.PositionOf(PlGrp[Code],[Plannergroup])})

    In addition, you can refer the following blog to achieve it, there are two methods(merge method and add a custom column method) include in this blog.

    VLOOKUP in Power Query Using List Functions

    Merge method

    Add a custom column method

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi IAM ,

You can add a custom column as below in the table IW38 in Power Query Editor, please find the details in the attachment.

= Table.AddColumn(#"Changed Type", "M_Planner", each PlGrp[Planner]{List.PositionOf(PlGrp[Code],[Plannergroup])})

In addition, you can refer the following blog to achieve it, there are two methods(merge method and add a custom column method) include in this blog.

VLOOKUP in Power Query Using List Functions

Merge method

Add a custom column method

Best Regards

Walt1010's avatar
Walt1010
Helper V
2 years ago

Hi, I understand these 2 methods, but what I don't understand is why you can't do the equivalent of SELECT.. WHERE.., if there is a relationship between the tables? In many cases the tables will be too dissimilar for a merge, and why should you have to use the language of lists in whats ostensibly an SQL DB?