Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Load a,b, Null() as c from xxxxx;
Load a,b, Null() as c from xxxxx;