Forum Discussion
Advanced ODBC Query - Pulling through a Summarized/Pre-Merged Column
Not clear what you are describing here. Is InMaster part of the InTrans table and you forgot to include it in the Select statement?
lbendlin InMaster is a separate table to InTrans but it's stored in the server as an expandable column in InTrans.
I know this because if I import the entire table I can see the column and click a drop down to select the columns from InMaster that I want to expand for.
It looks exactly the same as you'd expect it to you if you did a merge in Power Query between two tables but I just can't pull it through using the SQL query.
The only thing I've been able to do to get it to kind of work is do an inner join in the SQL and state exactly which column from InMaster I want.
Yes, that's what you are supposed to do. Run a native SQL query with all required joins. Does that not work for you?
lbendlin I'm able to pull through the specific column I want using a join in the native SQL query I've written in the advanced editor.
I was hoping that I would be able to pull through the entire expandable InMaster column instead of having to ask for individual columns during the join.
Thinking about it now, it's probably possible to bring through that expandable column by editing the SQL I have - I don't know SQL too well so I'd have to do more research.
Saying that, it's probably best practice only to ask the server for the columns I need instead of trying to drag the whole table in, isn't it?
