topic Re: Like in load statement, multiple matches in App Development

Like in load statement, multiple matches

Mt3 — Mon, 04 Apr 2022 15:28:08 GMT

Hi,

I am trying to figure out what the like statement could be incorporated within the load statement with many matching options.

What i would like to sort is all results, which contain letter A or B.

I tried wildmatch and like statement, but both results are not correct.

Would you have any suggestions on that?

LOAD
"ColumnName"
FROM [qvdlocation.qvd]
(qvd)

WHERE "ColumnName" like '%A%' or '%B%';

brunobertels — Mon, 04 Apr 2022 15:52:10 GMT

may be this

LOAD
"ColumnName"
FROM [qvdlocation.qvd]
(qvd)

WHERE match("ColumnName" ,'*A*' ,'*B*') ;

SunilChauhan — Mon, 04 Apr 2022 16:20:09 GMT

I think it's required wildmatch

may be this

LOAD
"ColumnName"
FROM [qvdlocation.qvd]
(qvd)

WHERE wildmatch("ColumnName" ,'*A*' ,'*B*') >0;