topic Mathc fieldvalue from two other tables in QlikView

Mathc fieldvalue from two other tables

Thu, 06 Nov 2014 11:06:44 GMT

Hi all!

Could you help me with this issue:

I have two tables:

Color

Green

Red

Orange

Yellow

Other

Item

Sweater for girls Green

dress Red

Bag Orange apple

Yellow coat

Blue jeans

The result I'm looking for after comparing these tables would then look like this:

Field1	Field2
Sweater Green for girls	Green
dress Red	Red
Yellow coat	Yellow
Bag Orange apple	Orange
Blue jeans	Other

Which is the best way to do it?

Re: Mathc fieldvalue from two other tables

vgutkovsky — Thu, 06 Nov 2014 22:33:07 GMT

Ksenia, if this is, in fact, the full extent of the problem, just code it manually using substringcount. For example:

if(substringcount(Item,'Red')>0,

'Red',

if(substringcount(Item,'Green')>0,

'Green',

....

) as Field2

If your real data is more extensive (as I'm guessing is the case), take a look at Rob Wunderlich's QlikView Cookbook. Specifically, the mappingWithWildcards.qvw example.

Regards,

Vlad

Re: Mathc fieldvalue from two other tables

danieloberbilli — Thu, 06 Nov 2014 23:14:58 GMT

Please find QVW with solution attached.

Re: Mathc fieldvalue from two other tables

Fri, 07 Nov 2014 08:30:34 GMT

Hi Vlad!

Thanks for your answer. You are right, it is a only simple example, i have more extensive data and it may change.

Thanks for advice, i'll take a look this book surely!

Re: Mathc fieldvalue from two other tables

Fri, 07 Nov 2014 08:31:08 GMT

Hi Daniel! Thank you! I like it!