Find String

[BRRLL99]

Hi,

I wanted to know columns which contain Pizza

NAME	CUISINES
A	Pizza, Italian
B	Burger, Fast Food
C	Pizza
D	Chinese, Japanese, Thai, Malaysian, Vietnamese, Asian
E	Italian, Continental, Cafe
F	Italian, Pizza, Fast Food
G	Italian, Pizza, Fast Food
H	Pizza, Fast Food
I	Ice Cream, Mithai, North Indian, Street Food

EXPECTED OUTPUT:

A	Pizza, Italian
C	Pizza
F	Italian, Pizza, Fast Food
G	Italian, Pizza, Fast Food
H	Pizza, Fast Food

[binu_acs · Accepted solution]

@BRRLL99 one way to do this with the contains function

https://help.alteryx.com/20221/designer/string-functions

[IraWatt · Accepted solution]

Hey @BRRLL99,

The filter tool helpfully has a contains option here in the configuration:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com