Insert row as per column reference

Question

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 nameDuplicatea1b2b2d3d3d3e2e2  Out Put Coloumn nameDuplicate counta1  b2b2  d3d3d3  e2e2

Felipe_Ribeir0 · Answer

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.

Insert row as per column reference.yxmd

KrishnaChithrathil · Answer

you can also try this way.

Insert row as per column reference.yxmd

grazitti_sapna · Answer

@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.

N rows between columns.yxmd