topic Why is resident load not working? in QlikView

Why is resident load not working?

qlikconsultant — Fri, 02 Jun 2017 06:19:17 GMT

I have the following Code:

Table1:
Load * inline
[
UK, A
1,Q1
2,Q1
3,Q1
4,Q2
5,Q2
6,Q2
7,Q3
8,Q3
9,Q3
10,Q4
11,Q4
12,Q4
];

Left join (Table1)
Load * inline
[
UK, B
1,1
2,1
3,1
4,1
5,1
];

Final_table: 
Load 
UK,
A,
if(B=1,1,0) as B
resident Table1;

drop Tables Table1;

If I run the script. I end vwith no tables. Goal is to have the Final_table. What is my error?

Re: Why is resident load not working?

RonaldDoes — Fri, 02 Jun 2017 06:22:47 GMT

Hello Markus,

You should use NoConcatenate, since the fields of Table1 and Final_table are the same. Also, I'd use "drop table Table1" instead of "drop tables Table1" since it's a single table you're dropping.

I've attached an example, hope this helps you.

Table1:
Load * inline
[
UK, A
1,Q1
2,Q1
3,Q1
4,Q2
5,Q2
6,Q2
7,Q3
8,Q3
9,Q3
10,Q4
11,Q4
12,Q4
];
Left join (Table1)
Load * inline
[
UK, B
1,1
2,1
3,1
4,1
5,1
];
Final_table:
NoConcatenate Load
UK,
A,
if(B=1,1,0) as B
resident Table1;
drop Table Table1;

Re: Why is resident load not working?

Sergey_Shuklin — Fri, 02 Jun 2017 06:23:16 GMT

Hello, Markus!

Use NoConcatenate before Final_table: