Errors when editing Load script in Qlik Sense

[JacobJones]

Hi,

I am trying to exclude rows based on field values in the load script.

I am brand new to doing this, should I be editing the locked auto generated load script? 

turning:

TriageCaseProcessingLocation,
CaseProcessingLocationType
FROM "Prod".dbo."TriageView";

into:

TriageCaseProcessingLocation,
CaseProcessingLocationType
FROM "Prod".dbo."TriageView"

WHERE Patient_ID = '123';

When I do that I end up getting errors, saying fields under the LOAD don't exist. Also sometimes when I remove the where statement i added, the script stops working.

Best,

Jacob

[Anil_Babu_Samineni · Accepted solution]

Because you have not loaded  "Patient_ID" into the table.

TriageCaseProcessingLocation,
CaseProcessingLocationType
FROM "Prod".dbo."TriageView"

WHERE Patient_ID = '123';

[Yoshidaqlik]

Hi

It seems to be ok,

can you pass the load of this table you want to filter?

regards

[JacobJones]

Just to be clear, to achieve this type of filtering I should be unlocking the auto-generated load script? There is no other place, except in the chart expression themselves, to exclude rows? Like in Data Management?