Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mwscott1
Creator
Creator

Return multiple Wildcards from one filed

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*');

1 Solution

Accepted Solutions
sunny_talwar

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*');

View solution in original post

1 Reply
sunny_talwar

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*');