Nesting Queries

[rpiboy_1]

Hi all, I've tried this several ways and not getting the result I'm expecting. Here is my scenario:

Let us say that I have Query Alpha that the result looks like this.

Alpha

ID	Name	Property	Boolean
1	Name1	Property1	True
2	Name2	Property2	False
3	Name3	Property3	True

Now, I'm writing a query called Beta, in Beta I want to use #"Alpha"[Name] as a list, but I need to filter on the [Boolean] value.

I of course can write this additional query that references #"Alpha" and will return the Name column as a list that has been filtered.

let
   #"Filtered Rows" = Table.SelectRows(#"Alpha", each #"Alpha"[Boolean] = true,
   #"Name" = #"Filtered Rows"[Name]
in
  #"Name"

#"Name"

List

Name1

Name3

Where I'm having trouble is I want to direclty incorporate the above query into Beta, so that it looks something like this... (but the derivations I've tried have not worked). For the purposes of this example, we'll assume the data in #"SomeQuery" looks like as follows:

SomeQuery

Name 1	Column2	Name3	Column4	Column5
<value>	<value>	<value>	<value>	<value>
<value>	<value>	<value>	<value>	<value>

 

Beta

let
  Source = #"SomeQuery"
  #"Removed Other Columns" =
    Table.SelectColumns(
        Source,
        let
          #"Filtered Rows" = Table.SelectRows(#"Alpha", each #"Alpha"[Boolean] = true),
          #"Name" = #"Filtered Rows"[Name]
        in
          #"Name"
    ),
  #"NextStep" = <some other transformation>(#"Removed Other Columns", ...),
  .....
in
  #"LastStep"

The result of #"Removed Other Columns" should look like:

#"Removed Other Columns"

Name1	Name3
<value>	<value>
<value>	<value>

I've tried several different syntaxual approaches and I'm not getting the result I expect, which is to carry on with the other steps. Instead I get the result of #"Name" not #"LastStep".

Thanks!

[rpiboy_1]

Bumping this up as I was hoping someone could lend some advice/input.

[AntrikshSharma]

@rpiboy_1 Share a mock up of the data with the code that you can written so far, you can share the file using google or onedrive.

[rpiboy_1]

I've added some additional detail to the original post to help further clarify the desired result and the form of the input.