Forum Discussion

barthhsk's avatar
barthhsk
Frequent Visitor
3 years ago
Solved

Extracting text as string from table in column

Hi,   I am struggling with following transformation:    From a column "aanleiding toezicht" I need to expand the tables without adding extra rows. Therefore I planned to create  a string of the l...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi barthhsk ,

    please try the following:

    Tabel2 = Table.AddColumn(Tabel,"aanleiding toezicht2", each if Value.Is([aanleiding toezicht], Table.Type) then Text.Combine([aanleiding toezicht][Element:Text],";")
else Tabel[aanleiding toezicht])
barthhsk's avatar
barthhsk
Frequent Visitor
3 years ago

Hi ImkeF,
Thank you for your fast reply. I tried your suggestion. With a slight adaptation - because of the not accepted column name - the problem was solved:

= Table.AddColumn(Tabel,"aanleiding toezicht2", each if Value.Is([aanleiding toezicht], Table.Type) then Text.Combine({[aanleiding toezicht][#"Element:Text"]},";")
else [aanleiding toezicht])

Combined with:

= Table.TransformColumns(Aangepast3, {{"aanleiding toezicht2", each if Value.Is(_,type list) = true 
then Text.Combine(List.Transform(_, Text.From), ";") else _}})