Replacing Values in Load Editor

[Mcs2021]

Hi, 

I have a column that has "1" and "-" as values. I would like to replace the "-" as "0". How would that look like in the data load editor? Thank you!

This is the example:

Lines Quoted
1
-
-
-
1
-

[stevejoyce]

When loading this field: Replace([Lines Quoted], '-',  0) as [Lines Quoted]

[Mcs2021]

Hi, thanks for your help. I think they are non-null values. How do I replace them? 

[Mcs2021]

In other words, if its not a "1", replace as "0".

[stevejoyce]

If([Lines Quoted] = 1, 1, 0)

if you are trying to replace nulls you can use alt() or newer versions of qliksense have coalesce().