Find String

Question

Hi,

I wanted to know columns which contain Pizza

NAMECUISINESAPizza, ItalianBBurger, Fast FoodCPizzaDChinese, Japanese, Thai, Malaysian, Vietnamese, AsianEItalian, Continental, CafeFItalian, Pizza, Fast FoodGItalian, Pizza, Fast FoodHPizza, Fast FoodIIce Cream, Mithai, North Indian, Street Food

EXPECTED OUTPUT:

APizza, ItalianCPizzaFItalian, Pizza, Fast FoodGItalian, Pizza, Fast FoodHPizza, Fast Food

binu_acs · Accepted Answer

@BRRLL99 one way to do this with the contains function

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

IraWatt · Accepted Answer

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