Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%';
hi
may be this
LOAD
"ColumnName"
FROM [qvdlocation.qvd]
(qvd)
WHERE match("ColumnName" ,'*A*' ,'*B*') ;
I think it's required wildmatch
hi
may be this
LOAD
"ColumnName"
FROM [qvdlocation.qvd]
(qvd)
WHERE wildmatch("ColumnName" ,'*A*' ,'*B*') >0;