Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to load a field to null value

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

1 Solution

Accepted Solutions
kji
Employee
Employee

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

View solution in original post

1 Reply
kji
Employee
Employee

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