none
Refresh doubts for the load disabled scenario RRS feed

  • Question

  • Hi, 

    I build 3 queries in PQ and all 3 queries are connected to a same DB. The second query is based on the first query's result and the third query is based on the second query's result. However, what I want is the last query's result. To shorten the loading time, I disabled the loading for query1 and query2. Only load the last query's result to the worksheet. My question is, for such a scenario, when I refresh the query will I get the correct result? Will the query1 and query2 be refreshed at the same time even the load is disable for them?

    Thanks.

    Regards,  

    Wednesday, January 21, 2015 1:38 AM

Answers

  • Hi Qilong,

    Yes, you will get the correct result. The 2 disabled queries will be evaluated and their outputs will affect what is evaluated and returned by the final query.


    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com, Twitter: @nimblelearn

    • Proposed as answer by Gil RavivMVP Thursday, January 22, 2015 9:21 AM
    • Marked as answer by Qilong L Friday, January 23, 2015 12:13 AM
    Wednesday, January 21, 2015 9:17 AM
    Moderator