topic Re: Error while loading data in QlikView

Error while loading data

Thu, 07 Aug 2014 06:28:41 GMT

Actually i have sql developer database in that i am trying to give '|' Pipe symbol for concatenation , but its not working here am sharing the QVW fie go through with that file and guide me .

Re: Error while loading data

ashfaq_haseeb — Thu, 07 Aug 2014 06:33:17 GMT

Hi,

Try below

OLEDB CONNECT TO [Provider=MSDAORA.1;User ID=hr;Data Source=orcl] (XPassword is JWFZHUJOVF);

Jobs:

Load *;

SQL SELECT "JOB_ID",

"JOB_TITLE",

"MAX_SALARY",

"MIN_SALARY"

FROM HR.JOBS;

JHS:

Load *,

"DEPARTMENT_ID" & "EMPLOYEE_ID" & "JOB_ID" as key1

;

SQL SELECT //cast("DEPARTMENT_ID" as char) || cast("EMPLOYEE_ID" as char) || cast("JOB_ID" as char) as key1 ,

"DEPARTMENT_ID"

"EMPLOYEE_ID",

"END_DATE",

"JOB_ID",

"START_DATE"

FROM HR."JOB_HISTORY";

Load *,

"DEPARTMENT_ID" & "EMPLOYEE_ID" & "JOB_ID" as key1

;

EMP:

SQL SELECT

"COMMISSION_PCT",

"DEPARTMENT_ID",

"DEPARTMENT_ID" as d_id,

EMAIL,

"EMPLOYEE_ID",

"FIRST_NAME",

"HIRE_DATE",

"JOB_ID",

"LAST_NAME",

"MANAGER_ID",

"PHONE_NUMBER",

SALARY

FROM HR.EMPLOYEES;

Dept:

Load *

;

SQL SELECT "DEPARTMENT_ID" as d_id,

"DEPARTMENT_NAME",

"LOCATION_ID",

"MANAGER_ID" as m_id

FROM HR.DEPARTMENTS;

Regards

ASHFAQ

Re: Error while loading data

maxgro — Thu, 07 Aug 2014 06:47:07 GMT

if you want to concatenate strings, in Oracle

use ||

not |

so this works, change your sql in same way

OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=dwh_staging;Data Source=dwcci1] (XPassword is xxxxxxxxxxxxxxxxxxx);

load *;

SQL SELECT

"TIP_ANNO" || "TIP_MESE",

"TIP_GIORNO",

"TIP_GIORNO_ANNO"

FROM "DWH_XXX"."D000_CALENDARIO_CCI";