Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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";
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.
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.
Thanks!