Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities 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. 

 

binu_acs
21 - Polaris

@calvincarr29 One way of doing this

binuacs_0-1670280941734.png

 

calvincarr29
8 - Asteroid

@binu_acs 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

binu_acs
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

@binu_acs and @Qiu Thank you both.

Labels
Top Solution Authors