How to replace null values in the flat file while transforming in QV?

[#1]

    Recently I have received an excel file as source data, which is having lot of null values in a dimension or two. When I tryied to do transforming in the Qlikview, I could find only normal captions like fill cells Above, Below, Left, Right, but I want to replace all the null values to particular value (manual entry). Please some one help me in sorting this out.

[vishsaggi]

Try this :

NULLASVALUE (Here:Your DimensionName thas HasNulls);

SET NullValue = '<Unknown>' ;

Then your Load script.

[#3]

Hi Vish,

This is very helpful.

Just eager to know Is there any other option in the QV itself (like Fill changes option) to do this changes rather than do it in the script.

[vishsaggi]

I am not pretty sure if we can handle that in Table file transformation wizard. Once you get the data into Qlikview we can transform accordingly with local Qlikview functionality. What exactly you are looking for ?