Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with few columns. One among them is Email-Id. My task is to categorize this Email-Id as 'Fake' or not.
I also have a reference file (excel file) using which I need to decide whether the Email-Id column in the above table is a Fake or not. The columns to be used in this Excel file are: Enabled Flag, Email Section, Control Text.
For your reference, I am attaching the Excel file.
I need assistance on how to write a piece of code or function that uses the above-mentioned columns in Excel file to categorize whether the Email-Id is 'Fake' or not.
Thanks, in advance !!
Hi,
You can try with the help of regular expression.
please refer below URL:
https://community.qlik.com/t5/QlikView-Scripting/Regular-expression-A-Z/td-p/851408
Thanks
Tushar