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 ;
IF FIELDB =2 AND FIELDC = 3 THEN FIELDA =9.
IF( FIELDB = 2 AND FIELDC = 3, 9, FIELDA) as FIELDA
Retrieving data ...