concatenated key / quotes format error

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

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

[#3]

It sure does! Thanks!