Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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