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