How to Write Entire Rows into Another File to Replace Corresponding Rows?

[christianpeterson20]

Hello - new Alteryx user here

I'm trying to write rows of data from an 'updated' file into the 'master' file and have been getting stumped. For example, I'd like to write the two records from the 'updated' file to replace the corresponding rows in the 'master' file.

Ex:

'Master' file pre-process:

Record	Data Element A	Data Element B	Data Element C
X1	45	New York	40-A
X2	24	San Francisco	50-A
X3	26	Miami	60-A
X4	87	Los Angeles	70-A
X5	98	Dallas	80-A

'Updated' file

Record	Data Element A	Data Element B	Data Element C
X3	45	London	10-B
X5	110	Hong Kong	10-Z

'Master' file post-process with the 'Updated' rows written in:

Record	Data Element A	Data Element B	Data Element C
X1	45	New York	40-A
X2	24	San Francisco	50-A
X3	45	London	10-B
X4	87	Los Angeles	70-A
X5	110	Hong Kong	10-Z

I've been trying to use the Join and Find & Replace tools, but haven't had success yet. I've gotten the Find & Replace tool to append the updated columns into the 'Master' file, but I don't know how to move those into the correct columns after that.

[Luke_C · Accepted solution]

Hi @christianpeterson20 

Here's how I'd approach this:

1. Join the datasets based on the Record Column
2. Only the 2 records being updated should come out in the J output. I de-select the old ABC fields and only select the new ABC fields.
3. Then, I union this data back together with the records that did not join (aren't changing)

[christianpeterson20]

Thanks - that works!