Tuesday 26 December 2017

microsoft excel - Use a Cell Value for a Paramater Value using in Power Query

I am using a query like below in power query Excel 2016:


let
Source = Odbc.Query("dsn=AS400", "select * from libm61.emleqpm1 where STN1 = '03' ")
in
Source

I want to replace '03' with a value form cell AD2


Is this possible to do ?

No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...