It is very easy to use the Find and Replace tool in Alteryx. Here’s a short tutorial on how to do it in simple steps:
- Inside Alteryx's workflow designer, head over to the left-side panel and find 'Find and Replace'. Drag it onto the canvas for further customization.
- After that, go to the first Input Data tool that contains your primary data and connect it to the input anchor (F) of your Find and Replace tool.
- Likewise, head over to another Input Data tool in the canvas that contains your secondary data. Connect its output anchor to the other input anchor (R) of your Find and Replace tool.
- Tap the Find and Replace tool to start making your desired configurations.
- Following that, go to the right-side panel to access the tool's settings page. To get started, go to the Search Criteria section and choose one from the list.
- Specify the column you wish to search and the column where you want to find values.
- Subsequently, go to the Replace section and choose 'Replace Found Text'.
- Tap the 'Replace Value' menu afterwards, then select the column that contains the data you want to use as replacements for the indicated values.
- Finally, the Find and Replace tool will process your data and make the corresponding data changes according to your configurations.
