Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
BartVA
Contributor III
Contributor III

Basic Resident question

This is probably a dumb question, for which my apologies, but why does this not work? (The result is nothing, tResult isn't created, "data model viewer" isn't even available):

tTemp4:
Load * 
Inline [
ID, Name, Age, Title
1, Wladimir, 31, Team Lead
2, Paul, 22, Technical Support Engineer
3, Mark, 40, Customer Support Engineer
4, Janne, 27, IT Specialist
];

tResult:
Load *
Resident tTemp4;

drop table tTemp4;
Labels (1)
  • SaaS

1 Solution

Accepted Solutions
AshutoshBhumkar
Partner
Partner

Hi, This is because of an auto concatenation of tables.

Use NoConcatenate keyword between two tables. The resident table is getting concatenated with the above one and getting dropped at the end. Hence no result is being shown.

 

tTemp4:
Load *
Inline [
ID, Name, Age, Title
1, Wladimir, 31, Team Lead
2, Paul, 22, Technical Support Engineer
3, Mark, 40, Customer Support Engineer
4, Janne, 27, IT Specialist
];

NoConcatenate

tResult:
Load *
Resident tTemp4;

drop table tTemp4;

View solution in original post

2 Replies
AshutoshBhumkar
Partner
Partner

Hi, This is because of an auto concatenation of tables.

Use NoConcatenate keyword between two tables. The resident table is getting concatenated with the above one and getting dropped at the end. Hence no result is being shown.

 

tTemp4:
Load *
Inline [
ID, Name, Age, Title
1, Wladimir, 31, Team Lead
2, Paul, 22, Technical Support Engineer
3, Mark, 40, Customer Support Engineer
4, Janne, 27, IT Specialist
];

NoConcatenate

tResult:
Load *
Resident tTemp4;

drop table tTemp4;

View solution in original post

BartVA
Contributor III
Contributor III
Author

Fabulous, thanks!!