Why is resident load not working?

[qlikconsultant]

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?

[RonaldDoes · Accepted solution]

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.

1. Table1: 
2. Load * inline 
3. [ 
4. UK, A 
5. 1,Q1 
6. 2,Q1 
7. 3,Q1 
8. 4,Q2 
9. 5,Q2 
10. 6,Q2 
11. 7,Q3 
12. 8,Q3 
13. 9,Q3 
14. 10,Q4 
15. 11,Q4 
16. 12,Q4 
17. ]; 
18.  
19. Left join (Table1) 
20. Load * inline 
21. [ 
22. UK, B 
23. 1,1 
24. 2,1 
25. 3,1 
26. 4,1 
27. 5,1 
28. ]; 
29.  
30. Final_table:  
31. NoConcatenate Load  
32. UK, 
33. A, 
34. if(B=1,1,0) as B 
35. resident Table1; 
36.  
37. drop Table Table1; 

[Sergey_Shuklin]

Hello, Markus!

Use NoConcatenate before Final_table: