Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
IF( FIELDB = 2 AND FIELDC = 3, 9, FIELDA) as FIELDA