Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See this discussion. Maybe Qlikview Components can help you, if not try the outer join option.
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.
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
See this discussion. Maybe Qlikview Components can help you, if not try the outer join option.
Hi
I used the outer join
it helps thanks
gidon