Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qlikconsultant
Contributor II

Why is resident load not working?

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?

1 Solution

Accepted Solutions
RonaldDoes
Contributor III

Re: Why is resident load not working?

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

Re: Why is resident load not working?

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

Re: Why is resident load not working?

Hello, Markus!

Use NoConcatenate before Final_table:

Community Browser