Forum Discussion

gadao's avatar
gadao
Frequent Visitor
4 years ago
Solved

Use Parameter as Query Reference in Source

I have query (query 1) that performs a lot of steps to correct the dataset, I load it to excel and then I loaded it back to PQ, Now I use this query (query_1) to perform other corrections, which give me some performance while I do the subsequent query steps.

 

But in the future I will change to query 1 and discard query_1...

 

The thing is, I would like to use a Parameter to rapidily change the reference.

Without using a parameter:

let

Source = #"query 1"

in

Source

 

I want to use the parameter value in the blue highlighted text.

 

 

 

Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, gadao 

    You can try the following solution:

    1. create a custom fuction SwitchQuery:

    (query as table)=>
let 
source = query
in source

    2. Invoked fuction:

    let
    Source = SwitchQuery(Query2)
in
    Source

     2. for the Main table:

    let
    Source = #"Invoked Function"
in
    Source

    You only need to change the query of the invoked function to change the query of the main table at any time.

     Result:

    Please refer to the attachment below for details.

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    Hi, gadao 

    You can try the following solution:

    1. create a custom fuction SwitchQuery:

    (query as table)=>
let 
source = query
in source

    2. Invoked fuction:

    let
    Source = SwitchQuery(Query2)
in
    Source

     2. for the Main table:

    let
    Source = #"Invoked Function"
in
    Source

    You only need to change the query of the invoked function to change the query of the main table at any time.

     Result:

    Please refer to the attachment below for details.

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ilton's avatar
    ilton
    Helper I
    4 years ago

    Hi gadao 

    Are you trying to use a variable to select wich query is going to be executed?

    If so, you can use a function that reads the parameter and selects the quey.

     

    If this helps onsider marking it as a solution

     

    • gadao's avatar
      gadao
      Frequent Visitor
      4 years ago

      I think isn't that...

       

      Let me put this way, let's say I have two queries in PQE and then i created a blank query.

       

      If I write: let Source = #"Query1" in Source | it will show the data from Query1 if I change the code for Query2 it will show the data in Query 2,

       

      I want a switcher to make this change using a parameter or any other thing.