Load data from Data Warehouse

Fri, 10 Apr 2015 14:59:24 GMT

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

topic Load data from Data Warehouse in QlikView