How to feel the column

[prma7799]

Hi All,

If I have one column in my table with some blank value and I want to feel that value with "NA".

How to do this?

Thanks

[prma7799]

Sorry I have excel sheet.

[#3]

Hi,

try this

load

     if(len(trim(field))=0,'NA',field) as field

from excel.

Regards

$@M

[tresesco]

Try like:

Load

          If(Len(Trim(YourField))=0, 'NA', YourField) as YourField

From <>;

[prma7799]

I want to do this activity using "Enable Transformation Step"

[prma7799]

And I have multiple column like that.

[tresesco]

If you are talking about Fill in the transformation step, it is actually filling with some other cell's value(from left/right/below/above); you can probably not fill with specific value.

[prma7799]

Hi Tresesco,

then what is another option to do this.

Thanks

[tresesco]

If they are really NULL, you could use NullAsValue, like:

NullAsValue *;

Set NullValue='NA';

Otherwise(if they are not nulls always but might have space or so), apart from doing similarly for all fields like showed above, you might handle them in the front end(replacing nulls or '-' with 'NA' in the chart) .

[ashfaq_haseeb]

Hi Prashant,

This might help you

NULL handling in QlikView

Regards

ASHFAQ