topic Re: Search in two fields in QlikView

Search in two fields

Wed, 28 Aug 2013 11:26:06 GMT

Hello,

I have two distinct tables. One table contains unique product fields and the other table contains fields which have the same products but which are spelt differently: I need to associate table 2 fields with the differently spelt products in Table 1:

Table1:

Product, Price

Apple Ipad, 10

Ipad Apple, 20

APPLE IPAD 2, 20

Trimmer, 4

CD, 1

CD 1, 5

25 CD, 10

Table2:

Product Catalogue

Ipad

keyboard

Samsung

Find attached a demo application.

Thank you in advance!

Re: Search in two fields

Wed, 28 Aug 2013 13:07:56 GMT

Hi Hero warrior,

Take a look at the attached qvw. Is this what you want to do ?

Regards,

Nicolas

Re: Search in two fields

Wed, 28 Aug 2013 13:15:03 GMT

Wow, thats exactly what I was looking for!!

I didnt know the 'like' function!

I had found a temporary solution using event triggers, but this is just perfect!

Thank you very much @Nicola Gious

🙂

Re: Search in two fields

CELAMBARASAN — Wed, 28 Aug 2013 13:18:24 GMT

Product:

LOAD * INLINE [

May be like this

Product, Price

Apple Ipad, 10

Ipad Apple, 20

APPLE IPAD 2, 20

Trimmer, 4

CD, 1

CD 1, 5

25 CD, 10

];

Catalogue:

LOAD * INLINE [

CatalogueID, Product Catalogue

1, Ipad

2, CD

3, keyboard

4, Samsung

];

LET vNoOfRows= NoOfRows('Catalogue');

FOR i=0 to vNoOfRows

LET vCategory = chr(39) &'*' & Peek('Product Catalogue',$(i),'Catalogue') & '*' &chr(39);

Left Join(Product):

LOAD

Product,

Peek('CatalogueID', $(i),'Catalogue') AS CatalogueID

Resident Product

Where WildMatch(Product, $(vCategory));

Re: Search in two fields

Wed, 28 Aug 2013 13:59:57 GMT

Thank you Celambarasan,

Neat as well