Null as value

[Anonymous]

Hi all,

I'm using 'Null as Value' function in load script and applying it in all fields.  Is there an easy way to apply in all and exclude some?

Today I know that if you want some fields to be filled with null you just apply null as value on them, but for debugging purposes I would like to go excluding some of fields from this function. For example, take the load script:

Load

       *

drop field 'value' ;

Is there a way to do that?

[Gysbert_Wassenaar · Accepted solution]

You can use NullAsNull to disable the NullAsValue for some fields:

//This enables NullAsValue for all fields except FieldA en FieldB.

NullAsValue *;

NullAsNull FieldA, FieldB;

// Load some data

MyTable

LOAD

     FieldA, FieldB, FieldC, FieldD

FROM

     MySource;

// Enable NullAsValue for all fields again

NullAsValue *;

[#3]

You can use NullAsValue & NullAsNull functions to manipulate the null values.

[Anonymous]

Thanks Gysbert!

It helped a lot.

I've got another question: including lastworkdate in a chart
Any help would be appreciated.