Hi ,
Excel 365
PC Windows 10 Enterprise
I am using Power Query to load 2 different table with the purpose of looking up information between the 2 table
Query 1 : DB Shipment 1
Query 2 : DB shipment 2
I am trying to add a customs column in DB shipment 1 with a customs formula list.positionOf, basically I am trying to reproduce what is shown on this website for Vlookup in Power Query using List Functions
Issue
When typing the name of my TAB "DB Shipment 2" and opening the bracket [] , the columns proposed will be the columns of the Table DB Shipment 1 when it should be the columns of DB Shipment 2 since I am calling that table
I really dont know what is wrong , I believe I have reproduce exactly what is shown on the video
Hi Pierre-Stephane,
I'm not sure why it wouldn't be displaying the correct columns. Can you please send a screenshot of what you see in the Custom Column dialog box when you're entering your formula. Also provide the formula you're trying to enter and I can test it at my end.
Mynda
Hi Treacy,
Thank you for getting back
Please find attached.
I have two tab
DB shipment 1
DB shipment 2
I am adding a customs column in DB shipment 1 . I am using the function list.PositionOf
Syntax
List.PositionOf(#"DB Shipment 2"[ < What I see after the bracket are only the column from DB shipment 1
Thank you
