Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Qlik Launches Open Lakehouse and advanced agentic AI experience in Qlik Answers! | LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Mt3
Contributor III
Contributor III

Data load - table naming

Hi,

Im loading data from db to an app directly.

Where is the proper place in the load script for table name, which i would like to see in Qlik?

Option 1:
// //LIB CONNECT TO 'connection-name';
// [Qlik Table name]:

// LOAD "a",
// "b",
// "c";

// SQL SELECT "a",
// "b",
// "c"
// FROM "db"."source_table";

 

Or

Option2:

// //LIB CONNECT TO 'connection-name';

// LOAD "a",
// "b",
// "c";

// [Qlik Table name]:

// SQL SELECT "a",
// "b",
// "c"
// FROM "db"."source_table";

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

Generally speaking, you want to place your table name prior to the Load statement for ease of reading, though I believe either will work from a technical perspective. Some load statements may not be a preceding load (there may be Resident loads, QVD loads, etc) so placing them elsewhere would be less consistent.

View solution in original post

2 Replies
Or
MVP
MVP

Generally speaking, you want to place your table name prior to the Load statement for ease of reading, though I believe either will work from a technical perspective. Some load statements may not be a preceding load (there may be Resident loads, QVD loads, etc) so placing them elsewhere would be less consistent.

Mt3
Contributor III
Contributor III
Author

Thanks!