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

[omar_velor]

Hi all,

Can you give me a hand with the following task?

Considering a simple table,

ID	Count
A	2
B	1
C	3
D	4

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,

ID	Count	ID-Count
A	2	A-1, A-2
B	1	B-1
C	3	C-1, C-2, C-3
D	4	D-1, D-2, D-3, D-4

Cheers!

[FrederikE · Accepted solution]

Hey @omar_velor,

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

[ShankerV]

Hi @omar_velor 

One way of doing this.

Step 1: Input

Step 2: 

Step 3: 

Step 4:

Step 5:

Step 6;

Many thanks

Shanker V