How to load a field to null value

Sat, 12 Jun 2010 11:02:29 GMT

I need to load 2 data sources into the same table.

So i have 2 LOAD

Load A, B
From xxxx

Load B, C
FROM YYYY

the thing is, i need to make both load to have the same column, otherwise it gives me error.

So, i'm trying to do, the following to tally both load, but still doesn't work, i'm having some syntax error. can someone help?

Load A, B, C=null()
From xxxx

Load A=null(), B, C

From xxxx

kji — Sat, 12 Jun 2010 11:07:22 GMT

Load a,b, Null() as c from xxxxx;

topic How to load a field to null value in QlikView