Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have a couple of questions :
(1) is there a function in QlikView which is similar to SQL's "like" function.
For example : I am trying to filter-out valid emails from the "Email" field in my database.
In SQL, it would be as easy as saying : "Select * from my_customers where email like '%@%';
(This makes sure that the email contains the symbol : @ )
Not surprisingly, this does not work in QlikView's script.
How can I accomplish the same thing here?
(2) the second part of my problem is to create a separate column in QlikView, which would contain boolean values "TRUE" or "FALSE", depending on whether or not the individual has a valid email.
For example : if the script is loaded, and an individual has a valid email, the string "TRUE" will be input into this separate field.
If the email is invalid (for example, does not contain the symbol '@'), then the value "FALSE" will be assigned to this separate field
Thanks
Worked like a charm!
Thanks for all the help. Much obliged