Create a flag in the script

madhuqliklondon — Sat, 16 Nov 2024 18:17:53 GMT

Hi all,

I am trying to create a flag in the script, the scenario is Sample company has subscriptions for customers, inventory, customer emails and in addition, employees can buy a subscription as well. So the flag I am trying to create is where subscription belongs to an employee then Yes else No. The join or lookup will be customer email to employee email.

I prefer not to use mapping load to keep the optimized load in load script and also I have to convert the email fields to Upper() as they are inconsistency with regards to email alphabet characters.

Thanks in advance.

Re: Create a flag in the script

Miguel_Angel_Baeyens — Wed, 29 Jul 2020 10:21:45 GMT

Since you have to already use the Upper() function, I would definitely use a mapping table as long as you have such table with employee IDs for which you can create the flag.

Alternatively, you can use the EXISTS() function in the field and use it for the flag:

Employees:
LOAD Upper(email_address) FROM File.qvd (qvd);

Subscriptions:
LOAD *,
If(Exists(Upper(email_address)), 1, 0) AS flag.Employee // field with the same name as the one loaded previously elsewhere in the script
//else see help link below
FROM File.qvd (qvd);

More reference on the Exists(): https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/InterRecordFunctions/Exists.htm

topic Create a flag in the script in QlikView

Create a flag in the script

Re: Create a flag in the script