Insert row as per column reference

[Lalaiah]

Hi Team,

I have data need to insert row as per duplicate records. Example  "b" having 2 records so i need row to be insert a between "b" and "d".

given sample out put. (if inserted 2 rows also that will be more help full)

Coloumn name	Duplicate
a	1
b	2
b	2
d	3
d	3
d	3
e	2
e	2
Out Put
Coloumn name	Duplicate count
a	1
b	2
b	2
d	3
d	3
d	3
e	2
e	2

[binuacs]

@Lalaiah One way of doing this

[DataNath]

Hey @Lalaiah, when you say 2 rows in between would be better, does this mean you're looking for N rows between records, where N is the count of column name? That's what I've gone for in my approach so apologies if not, but the workflow here performs a count, generates that many rows and then integrates them back into the main dataset:

[grazitti_sapna]

@Lalaiah , Please find the below solution if you are expecting null rows on the basis of number of entries for each id in column name field.

[KrishnaChithrathil]

you can also try this way.

[Felipe_Ribeir0]

Hi @Lalaiah 

Another of doing this (for 1 null row - first container or 2 null rows - second container):

If necessary, you can configure the second container to any value of null rows inside the Generate Rows tool.