Split multiple columns based on comma-separated values in cells

@Vestlink
,

I'm not clear that I understand exactly what you are trying to do.

In the examples you have listed it appears that you are trying to split on commas within a column and you want to make those results into an initially unknown number of additional columns. There are several ways to do this kind of thing with DSS. You could look at the split or extract recipes steps.

You then want to be able to repeat those steps across multiple columns that share a column prefix. (My guess is that you eventually plan to have a lot more than 2 columns or the names of the columns are not known while you are creating the recipe.)

The challenge you may be having is that the split and extract recipes steps only work on a single column at a time. And you either don't know the names of the incoming columns or there are a large enough number of columns that hand-selecting each column for spiting would be challenging. Is this a correct intuition on my part?

Do you know how to program in Python? If so, it may be possible to do what you want to do in a python visual recipe step.

Although, I've created a few python recipe steps to do some wonderful things. It is still a bit of a mysterious art to me how to actually create the kind of results you are describing. (Although, I believe it might be doable.)

You can find the documentation for Python Function steps here.

Here is an extended thread on Python Visual recipe steps.

Here is a knowledge base article on the topic.

Here is an example that is similar to your problem set.

Hope this helps a little bit. Can you clarify for others if the description above is what you are trying to do. Then others may be able to jump in here and give a bit more clarity. Please also let us know how you get on with your challenge. Most of us here enjoying solving puzzles like this.