Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 *;
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 *;
You can use NullAsValue & NullAsNull functions to manipulate the null values.
Thanks Gysbert!
It helped a lot.
I've got another question: including lastworkdate in a chart
Any help would be appreciated.