topic Re: Wildmatch with a list in App Development

Wildmatch with a list

biemello19 — Sat, 16 Nov 2024 18:18:27 GMT

Hy Guys,

I have 2 tables:
Table A: Contains some description about a lot of products like this:
Description
Blablablablabla Apple blablablabla
Blablabla Amazon blablablabla
...(a lot of lines)...

Table 2: With a column that contains codes like Apple, Amazon... (Filters)

So I need that these field from table 2 filter in description on table 1. The filter needs to have Apple, Amazon, and give to me the descriptions that contais these filters.

I think that I could use wildmatch (description, HERE IS MY DOUBT), I need that these codes on table 2 filter the description. I did the link table with table 1 and table 2.

With best regards,

Gabriel

Re: Wildmatch with a list

SerhanKaraer — Tue, 28 Jul 2020 06:30:18 GMT

Hi Gabriel,

You are right, you can do it with wildmatch.

First you have to unite your Table 2 brands as to be used in wildmatch.

tBrandsList:
LOAD Concat(chr(39) & '*' & Brands & '*' & chr(39),',') as BrandsList Resident table2;

// Assuming your field name is Brands in table 2

LET vBrands=Peek('BrandsList',0);

Then you can filter Table 1 with your wildmatch.

LOAD * Resident table1 WHERE WildMatch(Description,$(vBrands));

Another way to meet your needs is to split your Table1 with subfield into rows and then flag your records with applymap. I guess this method will be faster if your data is huge in volume.

Regards,