Forum Discussion

mitchpj75's avatar
mitchpj75
Helper I
3 years ago

Concatenation??

Hi all,    Just looking for some advice.  Below is my table (screenshot for context) This is the data format setout for ease of reading   case_id case_row_id Date of Call Call succes...
Need Help
Tips and Tricks
AlienSx's avatar
AlienSx
Super User
3 years ago

Hi, mitchpj75 

let
    raw_data = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjY2UNJRAmNDfUNDfSMDQwsgxy9fKVYHJmsIkjVCko1MLYZKG2HTjJA2xmu2MTazUWTBxpthkzWDmYxVrxnMZAtcsiCTDU2wOtoSr6Mt8QaICd7QNMEamiDZWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [case_id = _t, case_row_id = _t, #"Date of Call" = _t, #"Call successful?" = _t]),
    Source = Table.TransformColumnTypes(raw_data, {{"Date of Call", type date}}, "en-GB"),
    z = 
        Table.Group(
            Source, {"case_id"}, 
            { {"Date of Call", each Text.Combine(List.Transform([Date of Call], Date.ToText), ";")}, 
            {"Call successful", each Text.Combine([#"Call successful?"], ";")}}
        )
in
    z