Return multiple Wildcards from one filed

mwscott1 — Mon, 11 Jan 2016 16:13:14 GMT

I am able to return one wildcard value, but can not figure out how to return multiple wildcard values from one field. This is what I have and it returns all entries with "PAN" in the PART_DESC field. I also need to return values for 'DEL*' and 'LENO*'.

LOAD ORDER_DATE,

ASSET_NO,

SERIAL_NO,

PART_NO,

PART_DESC,

ASSET_LEASE_END_DT,

FLEX_FIELD_1

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

WHERE PART_DESC LIKE ('PAN*');

Re: Return multiple Wildcards from one filed

sunny_talwar — Mon, 11 Jan 2016 16:28:22 GMT

May be using WildMatch:

LOAD ORDER_DATE,

ASSET_NO,

SERIAL_NO,

PART_NO,

PART_DESC,

ASSET_LEASE_END_DT,

FLEX_FIELD_1

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Where WildMatch(PART_DESC, 'PAN*', 'DEL*', 'LENO*');

topic Return multiple Wildcards from one filed in QlikView

Return multiple Wildcards from one filed

Re: Return multiple Wildcards from one filed