Generate column in a dataset based on count stored in previous column

Question

Hi all,

Can you give me a hand with the following task?

Considering a simple table,

IDCountA2B1C3D4

I would like to create a third column with the concatenation of the ID and the number of counts, separated by commas. The output should look like this,

IDCountID-CountA2A-1, A-2B1B-1C3C-1, C-2, C-3D4D-1, D-2, D-3, D-4

Cheers!

FrederikE · Accepted Answer

Hey @omar_velor,

You can generate a row for each count-unit and then concatenate it again. See the attached WF.