Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list of Business Units 10100000, 10200100, 10200150, 1040000, etc.
I want to pull data only for business units that start with 10200XXX.
If I use the code below and I do where WWBusUnit = "10200100" it
will return the WWCustomerIndustry for that one Business Unit. However if I try
to use a wild card, it does not return any WWCustomerIndustry records.
What is the appropriate syntax or method to do what I want?
LOAD WWBusUnit,
WWCustomerIndustry
FROM
WWCustomerIndustry.qvd
(qvd)
Where WWBusUnit Like '*10200*'
Hi,
Try something like below:
LOAD BusinessUnit,
Category
FROM
E:\qlikview\Source\wildcard_Demo.xlsx
(ooxml, embedded labels, table is Sheet1)
where BusinessUnit like '1020*';
Hi,
Try something like below:
LOAD BusinessUnit,
Category
FROM
E:\qlikview\Source\wildcard_Demo.xlsx
(ooxml, embedded labels, table is Sheet1)
where BusinessUnit like '1020*';
Hi!
To get everything that starts with 10200, you can use this:
Where WWBusUnit Like '10200*';
I believe that in this case like is the best way.
Regards,
Gabriel
Yes that did it. I can't believe I was that close but couldn't get it. Appreciate the help
I would use; where wildmatch(BusinessUnit, '10200*');
Gives the same result, but might be more performant in some cases (e.g. large data sets)