Creating Duplicate Rows / copy rows to below

I am trying to copy a specific row data out of a database exactly same to a new row below, but not able to find out exact solution / tool.

It is something very small but I just cant figure out, help please.

Database
a	b	c	d	e	f	g
c	d	e	f	g	a	b
a	b	c	d	f	g	a

Result
a	b	c	d	e	f	g
c	d	e	f	g	a	b
a	b	c	d	f	g	a
c	d	e	f	g	a	b

Criteria to copy paste entire row is 'd' in column 2

Datasets

Accepted answers

afv2688

Hello @AjaySetty ,

Would this work for you?:

Regards

duplicate on condition.yxmd

All comments

Shalz

You can assign a record number and apply sort and tile

Qiu

@AjaySetty

Since you are saying "a specific row of data", so we can use Select Record Tool for this situation.

New Workflow2.yxmd

apathetichell

Note - if you want row 2 to follow each row - you would turn @Qiu's solution into a macro with a static input of row 2 and run it for all rows which are not row 2.

AjaySetty

Thanks @Qiu but will this work in a large database where the my condition 'd' is not just in row 2 and maybe in several other rows and i want to copy them as well?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703