We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
21 - Polaris

@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
21 - Polaris
21 - Polaris

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

Replace-r1.PNG

binuacs
21 - Polaris

@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
Top Solution Authors