filter items from a table

[gidon500]

Hello

I need your help if possible  to filter items from a table

I have 2 tables ( enclosed ) 

first is ITEMS where the is items , qty , price  - SHEET ITEMS

second file listitems  contain the parts that I need   to filter  - sheet list

the problem is that i get only the first few characters from the item

like 12*  or 17*  as shown in the file listitems 

I need to create a table that will contain the line from the items table 

where the items starts as shown in the listitems

the result should look like as shown

in file ITEMS sheet result

thanks for your help

gidon

[Gysbert_Wassenaar]

Like this:

T1:

LOAD Item,

     qty,

     price

FROM

ITEMS.xlsx

(ooxml, embedded labels, table is ITEMS)

where WildMatch(Item,'21*','17-*');

Your 17* match isn't correct since that will also find 173-7952, which isn't in your RESULT table.

[gidon500]

Hello

thanks for your fast respons

i cannot use this solution as the itemlist changes

from time to time and the list get bigger

is there other solution for such a request

gidon

[Gysbert_Wassenaar · Accepted solution]

See this discussion. Maybe Qlikview Components can help you, if not try the outer join option.

[gidon500]

Hi

I used the outer join

it helps thanks

gidon