Script with same name correct or not - "POLICY_STATUS" and "Policy Status" ?

[suvechha_b]

Hi All ,

Please kindly let me know , if the below script is correct -

"DWQMV_POLICY_DETAIL" :
LOAD "POLICY_ITEM_DETAIL_KEY",
"POLICY_ITEM_KEY",
"POLICY_STATUS" ,
"POLICY_IMPORT_DATE_BEGIN"
From 'lib://QlikData/Model_PolicyItem.qvd' (qvd)

"TempPolicyStatus":
LOAD
"POLICY_KEY",
Date(Max(POLICY_IMPORT_DATE_BEGIN)) as policy_IMPORT_DATE_END_MAX,
FirstSortedValue(POLICY_STATUS, -PD_IMPORT_DATE_END) as POLICY_STATUS_LATEST
Resident DWQMV_POLICY_DETAIL
Group By
"POLICY_KEY";

Left Join (DWQMV_POLICY)
Load "POLICY_KEY",
"POLICY_IMPORT_DATE_BEGIN"
IF( POLICY_STATUS_LATEST = 'Active'
or POLICY_STATUS_LATEST='A'
, 'Active',
if( POLICY_STATUS_LATEST='Cancelled' or
POLICY_STATUS_LATEST='I'
, 'Cancelled',
if( POLICY_STATUS_LATEST='Pending'
, 'Pending', POLICY_STATUS_LATEST))) as "Policy Status"
Resident "TempPolicyStatus";

drop Table TempPolicyStatus;

Can I write in the qliksense script "POILICY_STATUS" and "Policy Status" and will it be treated differently ?

[Ricardo_Gerhard · Accepted solution]

Absolutely, the fields are different: "POLICY_STATUS" and "Policy Status"

If you want to create a key, the field name must be the same.

Using data manager, Qlik Sense could detect due the content of the filed, and then create a key between both.