Error in If Condition

[seraphis]

I see the red coloured part in the code below highlighted in red in Qliksense also and this code does not execute.

I am trying to create a new table taking all fields from another table Case1 and also create a new field called AssetFlag. 

Case4:

Load *,
if Case_Flat_Case.Asset_Serial_Number <> Previous(Case_Flat_Case.Asset_Serial_Number) then
AssetFlag = "Yes";
end if
Resident Case1
order by Case_Flat_Case.Asset_Serial_Number,Case_Flat_Case.Date_Time_Opened asc;

[Gysbert_Wassenaar]

Inside a load statement you have to use the If function not the If script statement

If(Case_Flat_Case.Asset_Serial_Number <> Previous(Case_Flat_Case.Asset_Serial_Number ), 'Yes', 'No') as AssetFlag

Note, the 'No' is optional. If you don't supply the third argument to the if function it will return Null if the condition in the first argument evaluates to false.

[seraphis]

Thanks. It works!