Forum Discussion

smpa01's avatar
smpa01
Community Champion
8 years ago

Referencing query upto a certain step

Hi,

 

When a a query is refernced it brings the whole query. I was wondering if it possible at all to reference a query upto a certain step.

 

For example, suppose query "Q1" has 10 steps applied in it such as Step1, Step2, Step3...Step10.

 

I want to reference "Q1" in a way so that it bringsonly Step1-Step7.

 

Is there currently a way to do that?

 

Thank you in advance

Need Help

4 Replies

  • Stachu's avatar
    Stachu
    Community Champion
    8 years ago

    that's only possible withing the query itself so e.g. step11 can reference step7 & step12 can reference step10 & step11
    assuming what you describe is concerning multiple queries I would do the following
    1) create Q1_1-7 covering steps 1 to 7
    2) change Q1 to reference Q1_1-7 and then add steps 8-10
    3) reference Q1_1-7 in the other query

    • smpa01's avatar
      smpa01
      Community Champion
      8 years ago

      Stachuthanks for your reply. I am sorry I did not get it. Can you elaborate with an example please.

      • Stachu's avatar
        Stachu
        Community Champion
        8 years ago

        say this is your Q1 query, and you want to reference step Custom3
        Q1 - original syntax

        let
    Source = 1,
    Custom1 = Source+1,
    Custom2 = Custom1+1,
    Custom3 = Custom2+1,
    Custom4 = Custom3+1,
    Custom5 = Custom4+1
in
    Custom5

        I duplicate the query, and remove evything after Custom3, and name it
        Q1_1-3

        let
    Source = 1,
    Custom1 = Source+1,
    Custom2 = Custom1+1,
    Custom3 = Custom2+1
in
    Custom3

        I change Q1 to reference the new query, tthis way if steps 1-3 change I only need to make it once
        Q1 - new syntax

        let
    Source = #"Q1_1-3",
    Custom4 = Source+1,
    Custom5 = Custom4+1
in
    Custom5

        in the query that was supposed to reference till step3 I reference Q1_1-3 instead of Q1

        does it make sense now?