Overwrite column value

[RubenMoreno]

Hello,

I have the following question. I hope you can support.

I loaded a table in Qlik Sense called [Weekly BFE Monitoring Report] including columns [BFE Responsible] and [Prog Code].

Now I want to modify the values of the column [BFE Responsible] to "Not Applicable" ONLY if the value of [Prog Code] is equal to "P". For the rest of values of column [Prog Code],  values of column [BFE Responsible] should remain unchanged.

I tried with the following code but it is not giving the expected results:

[Weekly BFE Monitoring Report]:
LOAD
If ([Prog Code] = 'P', 'Not Applicable') as [BFE Responsible]
resident [Weekly BFE Monitoring Report];

Can you help? Thanks for the support.

Best regards,

Rubén

[dplr-rn · Accepted solution]

dont do it as an incremental load. do it as a preceding load.

[Weekly BFE Monitoring Report]:
LOAD
If ([Prog Code] = 'P', 'Not Applicable',[BFE Responsible]) as [BFE Responsible]
[Prog Code],
....
;
//your original load
load
[BFE Responsible]
,[Prog Code]
,....