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...
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.

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.