How to Use Contains in Alteryx

‍

It is very easy to use Contains in Alteryx. Here’s a short tutorial on how to do it in simple steps:

1. Inside Alteryx's workflow designer, head over to the left-side panel and find 'Formula'. Drag this tool onto the canvas and connect it to the Input Data tool or other sources.
2. Following that, go to the right-side panel and configure the selected tool. To get started, type your preferred Output Column Name into the provided input field.
3. Subsequently, click the 'Type' menu next to it.
4. Choose 'Bool' from the list of options.
5. After that, go to the formula field and type 'Contains'. Select it from the suggested results.
6. Replace String with '[' and select the column that contains the data you want to search.
7. Subsequently, type '[' once again and choose the column that contains the target keyword you want to check.
8. Finally, the Contains function will process your data and generate the corresponding response according to your configurations.