Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load data from Data Warehouse

Hi,

I loaded data from warehouse and the following sript apprears in qlikview. Should the script look like as below or it's not good practice

NAPS_APPL_WORKFLOW_HISTORY:

LOAD "ACTIONED_USER_ID",

"APPL_ID",

"APPL_TRANS_TMSTMP",

"STATE_CDE",

"WRKFLW_ACTIVITY_DESCR",;

SQL SELECT "ACTIONED_USER_ID",

"APPL_ID",

"APPL_TRANS_TMSTMP",

"STATE_CDE",

"WRKFLW_ACTIVITY_DESCR"

FROM "NAPS_APPL_WORKFLOW_HISTORY"

where APPL_TRANS_TMSTMP >= '2015-03-07 00:00:00';

NAPS_APPL_REFERRAL_REASONS:

LOAD "APPL_ID",

"APPL_REFER_RSN_CDE",

"APPL_REFER_TMSTMP";

SQL SELECT "APPL_ID",

"APPL_REFER_RSN_CDE",

"APPL_REFER_TMSTMP"

FROM "NAPS_APPL_REFERRAL_REASONS";

0 Replies