topic Re: Changing a field value based on another field value during load in QlikView

Changing a field value based on another field value during load

Danny_Langley — Tue, 27 Oct 2015 17:43:27 GMT

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!!

Re: Changing a field value based on another field value during load

swuehl — Tue, 27 Oct 2015 17:53:00 GMT

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

Recipes | Qlikview Cookbook

Re: Changing a field value based on another field value during load

sunny_talwar — Tue, 27 Oct 2015 17:53:15 GMT

Probably something like this:

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

Re: Changing a field value based on another field value during load

Danny_Langley — Tue, 27 Oct 2015 18:05:31 GMT

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