Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How to understand the role of macth function in the where part of the Load statement?
see in the document the explanation of mixmatch is as follows:
Example Result
mixmatch( M, 'Jan','Feb','Mar') | returns 1 if M = jan |
If I have a field M with values including'Jan','Feb','Mar', then I write where mixmatch( M,'Jan','Feb') in the load statement,Is there only data of'Jan' and'Feb left in the loaded data?
I don't understand why this function is equivalent to IN in SQL.Isn't it returning a number?
I am very confused now, can anyone explain the usage of the function?
will be grateful for your help.
Henric's explanation. Even though it is not necessary, I generally write the where clause like this:
Where Mixmatch(M,'Jan','Feb') > 0;
I find it less confusing.
Henric's explanation. Even though it is not necessary, I generally write the where clause like this:
Where Mixmatch(M,'Jan','Feb') > 0;
I find it less confusing.