Forum Discussion

flinch's avatar
flinch
Icon for Helper I rankHelper I
6 years ago
Solved

Splitting a list

Hi, fairly new to all of this so I am sure there are easier ways to do what I am trying to do. Right now I will settle for any old way though, having tried for ages with no luck. I have a debtors ag...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    It's all case sensitive. 

     

    Your Group by text needs to be Group By - So try the following - 

     

    = Table.AddColumn(#"Filtered Rows", "Custom", each if Text.Contains([Column1], "Group By") then [Column1] else null)

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

here another way

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Lc67FcQgDETRXhQ7AX1dC8cR238Nq4EJLyA91pK9hzwypsr3LPkNaKpRs6XmlLbMg7KWRx7tjZeRde8mtmS9FO7eSgpbKoNzUAYLirlw1hVzbvyZnnqfXaGu3blboCrW7dSze98f", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Colum1 = _t, Column1 = _t]),

    Headers = {"cc1","cc2","cc3","cc4"},
    grp = Table.Group(Source, {"Colum1"}, {{"all", each List.Skip(_[Colum1])}},GroupKind.Local,(x,y)=> Number.From(List.Contains(Headers,y[Colum1]))),
    tab=Table.FromColumns(grp[all],grp[Colum1])
in
    tab