Unqualify in qliksense script not working

[ashmitp869]

Hi there,

Pls assist me to unqalify the VISITID .

My script below :

[ACP ]:
LOAD
FACILITY,facility_name
DOB,
"AGE",
SEX,
VISIT_ID
FROM [Data.xlsx]

left join ([ACP ])
LOAD
facility_name,
"facility_identifier"
;
SQL SELECT *
FROM "view";

qualify *;
unqualify VISIT_ID,facility_identifier,facility_name;

[ACP Final]:
Load "facility_identifier" & '-' & "VISIT_ID" as VISITID,
*
Resident [ACP ];

Unqualify VISITID;

Drop Table [ACP];

Drop field VISIT_ID,"facility_identifier",facility_name from [ACP  Final];

Unqualify *;

Still getting the below :

[rubenmarin]

Hi, this image shows 'ACP Advance Care Plan Final' as tabla and that table is not shown on script.

If it is the [ACP final] table it could be beacuse you have "unqualify VISIT_ID,facility_identifier,facility_name;"

And the field is called VISITID, so remove the underscore from unqualify: "unqualify VISITID,facility_identifier,facility_name;"