Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create custom column with cocatenated value

Hello My table has 5 columns with column header Col1, Col2, Col3, Col4 and Col5 All of them contains values True or False In Power Query I will create new custom column with name Col6 This Column...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    Try this as code fro your custome column:

    = Text.Combine({if [Col1] then "Col1" else null,if [Col2] then "Col2" else null, if [Col3] then "Col3" else null,if [Col4] then "Col4" else null,if [Col5] then "Col5" else null}, "|")

     


    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

try also this

 

let
    Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCikqTVXSgVFuiTnFyDRYOFYnGl0emy6QMjR5bMpjYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Colonna1 = _t, Colonna2 = _t, Colonna3 = _t, Colonna4 = _t, Colonna5 = _t]),
    #"Modificato tipo" = Table.TransformColumnTypes(Origine,{{"Colonna1", type logical}, {"Colonna2", type logical}, {"Colonna3", type logical}, {"Colonna4", type logical}, {"Colonna5", type logical}}),
    cols=Table.ColumnNames(#"Modificato tipo"),
    #"Aggiunta colonna personalizzata" = Table.AddColumn(#"Modificato tipo", "WhereIsTrue", each Text.Combine(List.Transform(List.PositionOf(Record.FieldValues(_),true, Occurrence.All),each cols{_}),"|"))
in
    #"Aggiunta colonna personalizzata"