I need to update the value in FIELDA based on the value in FIELDB in the LOAD process.

[#1]

When I load my data from an existing QVD file I want to change the value in FIELDA based on the values in FIELDB and FIELDC. I can not get the IF Then Else logic to work. I am using Release 7.5.

Something Like ;

Load *

IF FIELDB =2 AND FIELDC = 3 THEN FIELDA =9.

From ABC.QVD(qvd);

[#2]

IF( FIELDB = 2 AND FIELDC = 3, 9, FIELDA) as FIELDA