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])
ImkeF's avatar
ImkeF
Community Champion
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])