Forum Discussion
Power Query LookUp in another table
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
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
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?
Anonymous and amitchandak
Is there a preference as far as optimizing my query as to which method I use?
I need a single column of data from a different query. Is it more optimal to merge tables and then only expand the column that I need or do this list lookup?
I can tell you that I just tried it and after trying to load, it sat spinning at the evaluating stage for nearly an hour..
I ended up canceling and doing the merge instead which went right away.
