split concatenated values into multiple columns

Hi,

Need help with splitting the concatenated values into multiple columns
I know we can use Cell Splitter, however it can be used for 1 column at a time.
I wanted to run on multiple columns which have concatenated values.
In the image given below, “|-|” is my delimiter, similar to this column I’ve other columns with different concatenated values…
image

Here is the output I’m looking for
image

It is been quite few months, and I forgot how to use variables and loop through the columns :sweat_smile:

Thanks

I go the solution for it… had to use Column List loop
image

Need a help though

in the column names, how do I change [0] to reflect as [1], [1] to reflect as [2]… etc…
I’m not good with regex.

image

Thanks

Hi @Asghar

The Column List Loop Start creates a flow variable: currentColumnName

afbeelding

Use this flow variable in your Cell Splitter node.

afbeelding

And you are good to go.

gr. Hans

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.