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

Replace a row with data in a specific position

calvincarr29
8 - Asteroid

I need to combine two text inputs -- rather replace two rows with data in a specific position. 

 

1.PNG

2.PNG

 

I need the values in Returns & Throwbacks/Throwout (bottom) to replace their respective rows in (top).

6 REPLIES 6
calvincarr29
8 - Asteroid

The empty columns are there on purpose for I'm outputting the data onto a template based on cell positions. 

 

binuacs
20 - Arcturus

@calvincarr29 One way of doing this

binuacs_0-1670280941734.png

 

calvincarr29
8 - Asteroid

@binuacs Thank you for your solution. 

 

Do you know a way to get them in this specific order?

 

calvincarr29_0-1670281094521.png

 

Qiu
20 - Arcturus
20 - Arcturus

@calvincarr29 
We do a Join first and union back with data as below.

Replace-r1.PNG

binuacs
20 - Arcturus

@calvincarr29 I added a record id tool and joined it with the final output to get the same order

 

binuacs_0-1670281548427.png

 

calvincarr29
8 - Asteroid

@binuacs and @Qiu Thank you both.

Labels