DataTable Columns

[Anonymous_Hippo]

hello,

I have datatable with multiple rows. Each row contains 3 different values, separated with (“,”).
These values are currently all in the same column. Can I put them to their own columns each by some kind of assign action?

Cheers

[ppr (Peter Preuss)]

we can split the valu into the different items by:

you can start by assigning a target structure e.g. manually with the help of Build datatable activity

then iterate ( e.g. for each) over the origin datatable,
split the string - e.g. row(ColNameOrIndex).toString.Split(","c)
add it to the target datatable - add datarow activity