Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
gopi1krishnna
Contributor
Contributor

Categorise Emails

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 !!

1 Reply
tush
Creator II
Creator II

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