Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Replace a row with data in a specific position

calvincarr29
7 - Meteor

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
7 - Meteor

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

 

binuacs
17 - Castor

@calvincarr29 One way of doing this

binuacs_0-1670280941734.png

 

calvincarr29
7 - Meteor

@binuacs Thank you for your solution. 

 

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

 

calvincarr29_0-1670281094521.png

 

Qiu
19 - Altair
19 - Altair

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

Replace-r1.PNG

binuacs
17 - Castor

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

 

binuacs_0-1670281548427.png

 

calvincarr29
7 - Meteor

@binuacs and @Qiu Thank you both.

Labels