topic Re: Data load - table naming in App Development

Data load - table naming

Mt3 — Sun, 13 Nov 2022 12:50:32 GMT

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";

Option2:

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

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

// [Qlik Table name]:

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

Re: Data load - table naming

Or — Sun, 13 Nov 2022 13:14:03 GMT

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.

Re: Data load - table naming

Mt3 — Sun, 13 Nov 2022 13:32:09 GMT

Thanks!