Forum Discussion

mechanix85's avatar
mechanix85
Helper I
8 years ago
Solved

help with a custom function

Hello, how to simplify the function if the query? (Table.AddColumn) too lazy to write up to 20 function attachments if

 

 

let
    Souce= {"power querry","poweer query","pooower que1ry"},
    #"Table.FromList" = Table.FromList(Souce, Splitter.SplitByNothing(), null, null, ExtraValues.Error),


    #"Table.AddColumn" = Table.AddColumn(Table.FromList, "Group", each if Text.Contains([Column1],"power") then "power" else
if Text.Contains([Column1],"query") then "query" else
null)



in
    #"Table.AddColumn"

 

3 Replies