Join columns of text, but join those that contain text

[Anonymous]

Good afternoon, I hope you can help me, how can I join columns that contain text by and those that do not have text, I do not join them since as I am using a - to the box does not have text, it places it for me

Example

Incomplete

GRUPO_Administracion Cuentas de Red-Software-Falla Funcionalidad- 

Complete

GRUPO_Soporte Equipo Usuario Final-Software-Falla Funcionalidad-Mal funcionamiento aplicativo

wants to achieve that I only join the cells that contain text

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

here is the solution,

Text.Combine( List.Select(Record.FieldValues(Record.FromList({[Column1],[Column2],[Column3]},type [Column1 = text,Column2=text,Column3=text])),each _<> "" and _ <> null),"," )

Code in Advanced Editor

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlTSUQKiZKVYnWgQIwWIU8GcVCArHSQbGwsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}),
    #"Inserted Merged Column" = Table.AddColumn(#"Changed Type", "Merged", each Text.Combine( List.Select(Record.FieldValues(Record.FromList({[Column1],[Column2],[Column3]},type [Column1 = text,Column2=text,Column3=text])),each _<> "" and _ <> null),"," ))
in
    #"Inserted Merged Column"

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-xiaotang Hello, good afternoon, I get an error, is it possible to do it but in DAX?