Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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*');
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*');
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*');