Referencing query upto a certain step

[smpa01]

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

[Stachu]

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]

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

[Anonymous]

Yes, that's a really confusing reply!

[Stachu]

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?