Basic Resident question

[BartVA]

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;

[AshutoshBhumkar · Accepted solution]

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;

[BartVA]

Fabulous, thanks!!