topic concatenated key / quotes format error in QlikView

concatenated key / quotes format error

Mon, 01 Aug 2011 08:49:15 GMT

Hi All,

I am trying to make a concatenated key, but it gives errors no matter what I try.

So who can correct this statement:

pricelist:

SQL

SELECT

"ID_ARTIKEL" & "|" & "ID_RELATIE" & "|" & "PRIJSLIJST_JAAR" as PRIJSLIJST_ID,

"PRIJSLIJST_ARTIKELBEDRIJFGROEP"

FROM CENDRISBI."V_QV_DIM_JDE_PRIJSLIJST";

I am not sure how the quotes work and when to use them...

Greetings and thanks!

Wouter

Re: concatenated key / quotes format error

Miguel_Angel_Baeyens — Mon, 01 Aug 2011 08:57:37 GMT

Hello Wouter,

Do a LOAD and create the key there instead of using the ODBC driver

pricelist:
LOAD ID_ARTIKEL" & "|" & "ID_RELATIE" & "|" & "PRIJSLIJST_JAAR" as PRIJSLIJST_ID,
     PRIJSLIJST_ARTIKELBEDRIJFGROEP";
SQL SELECT ID_ARTIKEL, ID_RELATIE, PRIJSLIJST_JAAR, PRIJSLIJST_ARTIKELBEDRIJFGROEP
FROM CENDRISBI."V_QV_DIM_JDE_PRIJSLIJST";

Although it's not mandatory, the LOAD is very very helpful when loading data into QlikView, since you can make use of any available function in QlikView in order to clean your data an prepare the fields for your charts dimensions and expresions (conditionals, concatenations and so).

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: concatenated key / quotes format error

Mon, 01 Aug 2011 10:57:54 GMT

It sure does! Thanks!