Conditional selection Table

[smpa01]

Hello Experts,

I have Raw data as following

let
    S = {{1},{0},{0},{2}},
    CT = Table.FromList(S, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    AC= Table.AddIndexColumn(CT, "Index", 1, 1)
in
    AC

Is there a way to select this table with where Column1 lists <>{0} after AC in one step

let
    S = {{1},{0},{0},{2}},
    CT = Table.FromList(S, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    AC= Table.AddIndexColumn(CT, "Index", 1, 1),
    #"Expanded Column1" = Table.ExpandListColumn(AC, "Column1"),
    #"Filtered Rows" = Table.SelectRows(#"Expanded Column1", each ([Column1] <> 0))
in
    #"Filtered Rows"

Desired Output

I want to reach to output from AC in one step. Is it possible ?

Thank you in advance.

[smpa01 · Accepted solution]

let
    S = {{1},{0},{0},{2}},
    CT = Table.FromList(S, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    AC= Table.AddIndexColumn(CT, "Index", 1, 1),
    Custom1 = Table.SelectRows(AC, each [Column1]<>{0})
in
    Custom1

[Anonymous · Accepted solution]

Maybe something like this?

let
    S = {{1},{0},{0},{2}},
    AC= Table.AddIndexColumn(Table.FromList(S, Splitter.SplitByNothing(), null, null, ExtraValues.Error), "Index", 1, 1),
  
     #"Filtered Rows" = 
        Table.SelectRows(
            Table.ExpandListColumn(AC, "Column1"), each ([Column1] <> 0))
in
    #"Filtered Rows"

Could also write a fucntion with all the steps and when you call it it will only show the function name. Just a thought

[smpa01]

great @Anonymous  appreciate it. Thank you very much for stopping by. Better to have more aresnal and I prefer that way. Thanks for the contribution.

[Anonymous]

My pleasure. This place is great to see the different ways of solving problems. And always in for a good Power Query question 🙂

[smpa01 · Accepted solution]

let
    S = {{1},{0},{0},{2}},
    CT = Table.FromList(S, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    AC= Table.AddIndexColumn(CT, "Index", 1, 1),
    Custom1 = Table.SelectRows(AC, each [Column1]<>{0})
in
    Custom1