It is very easy to use Contains 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 'Formula'. Drag this tool onto the canvas and connect it to the Input Data tool or other sources.
- 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.
- Subsequently, click the 'Type' menu next to it.
- Choose 'Bool' from the list of options.
- After that, go to the formula field and type 'Contains'. Select it from the suggested results.
- Replace String with '[' and select the column that contains the data you want to search.
- Subsequently, type '[' once again and choose the column that contains the target keyword you want to check.
- Finally, the Contains function will process your data and generate the corresponding response according to your configurations.
