SEARCH FOR CERTAIN WORDS AND ASSIGN THEM A VALUE

[Shahas]

Hi All,

I have a requirement where in if a column, say A contains values 'abc','cdf','egh','hij' then all those has to be changed to say 'CHECK'. How do i implement this in alteryx without using multiple formula tool?

Thanks in advance

[Raj]

In Alteryx, you can achieve the desired transformation without using multiple Formula tools by using the Multi-Field Formula tool. The Multi-Field Formula tool allows you to apply transformations across multiple fields simultaneously.

"IF [A] IN ('abc', 'cdf', 'egh', 'hij') THEN 'CHECK' ELSE [A] ENDIF"

Hope this helps.

[Raj]

1. Drag and drop a Multi-Field Formula tool onto your Alteryx workflow canvas.

2. Connect the input data source to the Multi-Field Formula tool.

3. Click on the Multi-Field Formula tool to open its configuration panel.

4. In the "Fields" section, select the field (column) you want to modify, in this case, column A.

5. In the "Formula" section, enter the following expression:(which is given above)

[Dina · Accepted solution]

Is this what you are looking for? 

IIF(Contains("abc" ,[A]) or
Contains("cdf" ,[A]) or
Contains("egh" ,[A]) or
Contains("hij" ,[A]) ,

"CHECK",[A])

[Shahas]

Hi @Dina @Raj both the solutions works. Thank u both for quick response