Forum Discussion

campelliann's avatar
campelliann
Post Patron
4 years ago
Solved

Reference a column from another table in "Add custom column" - PQuery

      Hi,

I would like to perform a List.Positionof, and I need to access a column from another table (the list). When I call for the Table "Combo_lookup" and then try to write the column, I only get the columns from the current table. 

Is there a way to do this? I just saw a video on youtube (although it was PQ for excel), and they perform this without problems.

 

Thanks

 

 

  • PQ editor is not intelligent enough to infer the column names from another table. You will need to type column name manually. 

1 Reply

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional

    PQ editor is not intelligent enough to infer the column names from another table. You will need to type column name manually.