Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

I would like to duplicate specific rows

knozawa
11 - Bolide

Hello,

 

I would like to duplicate specific rows.

 

I have a list of x and y coordinates:

Sample Coordinates.png

I am joining this with another sheet:

Sample Lines.png

 

When I use the Join tool using [Point] field, I cannot join point 6.  Since point 1 and 6 have the same x and y coordinates, I would like to duplicate point 1 rows.

 

 

I tried to use the Generate Rows tool, but it didn't work.

Sample Generate Row.png

 

Does anyone know how to duplicate specific rows?

 

Thank you,

Kazumi

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

After you join the data, you get something like:

 

Line POINT Result X Y

 

You can then join your data to the 1st table again (this time on X & Y as the keys) and get:

 

Line POINT Result X Y POINT2

 

That will give you 2 rows for (1 & 6 having same XY coordinates).

 

Now you can drop POINT and rename POINT2 and you should have the right results.

 

Or so I think.....

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
KaneG
Alteryx Alumni (Retired)

The other simple way is to filter off the rows that you want to duplicate and then union them back on to the original set.

saideepuikey
6 - Meteoroid

Thanks Kane.

Labels