Changing a field value based on another field value during load

[Danny_Langley]

Hi there,

I'm relatively new to Qlik so this is probably an easy question, but I just can't wrap my head around it for some reason. I'm working in QlikView with a budget financial data set so there is a "Category" for each expense (e.g., "Medical", "Clothing", "Food", etc.). You can tell the categories for some transactions are incorrect based on the description (e.g., "ABC Clothing Store") is categorized at Medical.

I would like to clean this during load...so the logic would be... if Description is like '*clothing*' then Category = "Clothing"... or something like this.

Thanks in advance for any help!!

[swuehl]

Look into 'Mapping with Wildcards' in Rob's recipe collection

Recipes | Qlikview Cookbook

[sunny_talwar · Accepted solution]

Probably something like this:

If(WildMatch(Description, '*Clothing*'), 'Clothing', Category) as Category

[Danny_Langley]

Thanks a lot Sunny! Worked like a charm. And thanks swuehl for the recipe collection resource. Looks like it could be very helpful!