Transform data values

[alexjesplata]

Hi I am new to Qlik Sense. 

I uploaded a csv file for hospitalizations, there are some values across different  columns that appear as -9999 and would like to convert them to 0. 

In SQL I would have used the CASE statement to do this. How could I do it in the data load editor script? 

Thanks

[avinashelite · Accepted solution]

Try like this 

If(Column_name=-9999,0,Column_name) as Column_name