Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!