Search in two fields

[#1]

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

    CD

    keyboard

    Samsung

Find attached a demo application.

Thank you in advance!

[#2 · Accepted solution]

Hi Hero warrior,

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

Regards,

Nicolas

[#3]

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

🙂

[CELAMBARASAN]

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));

NEXT

[#5]

Thank you Celambarasan,

Neat as well