Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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;