We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Add Data to a File by Matching a String

8 - Asteroid

I have a file, let's call it file A, which has the following 5 fields:


IDNameCityFunded?Cost ($)
1Car theft preventionKansasYes100000
2Weapon UpgradesTorontoYes50000
50FortificationsCharlottetown No250000


Let's say I have another file, File B, with the same 5 fields, but with over 5000 sets of data already in it. All of the ID's in file A are already in file B. I just need to make updates to the fields Funded? and Cost ($).


I've tried using a very simple approach using find and replace:




However, this only appends them to file B (creates a whole new column). I want to replace/add the data from file A into the file B fields that already exist. Also, I do not know how to then overwrite file B after having used find and replace.

17 - Castor

@shaheer If both the files are having the same ID then use the join tool to connect both files and make the changes. Attaching a sample workflow




8 - Asteroid

Use a Join tool, join on ID.  Deselect Funded and Cost from the File B stream and keep them selected from File A stream - make sure no renames for the File A fields.  Then use an output tool to output to a new file.  I recommend writing out to a new file rather than writing over your existing File B, unless you're 100% your flow is working and you will never need to go back and reference original File B.  If possible, make a copy of File B, before you overwrite it if you really insist on the Output tool overwriting the existing file.

Oh, if you do set it up to overwrite the existing File B that you're reading in, you'll want to include a Block Until Done tool between Join tool and Output tool.

8 - Asteroid

Can you explain why we uncheck the Funded and Cost columns in the join tool?

17 - Castor

@shaheer Since you wanted to update the left table fields (Funded?, Cost) with table from the right, I deselected the values from and included only the fields from the right table, If you dont unselect them , you will values from both the tables