Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Synthetic Keys not created automatically

People, I started working with Qlikview last week, and there's my problem bellow.

I have to load 2 tables with finance information, and they have 3 columns in common. When I load, give me an error: 'Execution of Script Failed. Reload old data?'

Check the statements bellow:

SQL SELECT

MONTHY,

QUARTER,

YEAR

FROM "DBM_MKT".dbo."TIME";

SQL SELECT

PK_AGENCY,

NAME_AGENCY,

DISTRICT,

SR,

SUAT,

REGION,

WORKERID,

NAME_WORKER

FROM "DBM_MKT".dbo."GEO"

WHERE SUAT LIKE 'AREA%';

SQL SELECT

PK_AGENCY,

MONTHY,

PRODUCT,

TRANSACTION,

QUALITYSELL,

AMOUNT

FROM "DBM_MKT".dbo."QUALITY_SELL";

SQL SELECT

PK_AGENCY,

MONTHY,

PRODUCT,

SUMVALUE

FROM "DBM_MKT".dbo."SELL_VALUE";

Someone can help me?

Tags (2)
14 Replies
MVP
MVP

Re: Synthetic Keys not created automatically

Synthetic keys with large data can cause the issue. Try to reload with Debug mode -> Limited load, does the issue persist?

Not applicable

Re: Synthetic Keys not created automatically

It doesn't help. The issue remains. Thanks

MVP
MVP

Re: Synthetic Keys not created automatically

Loading single table?

Not applicable

Re: Synthetic Keys not created automatically

I reload on Debug mode and all tables were read and the script finished. But when I click 'Close' the message 'Execution of Script Failed. Reload old data?' appears again.

MVP
MVP

Re: Synthetic Keys not created automatically

I would reload the first table and see, if works, then the first two together and so. That would give you a better picture of the issue.

Not applicable

Re: Synthetic Keys not created automatically

I tried to load each table alone and it is okay, the problem is when I load QUALITY_SELL and SELL_VALUE together.

MVP
MVP

Re: Synthetic Keys not created automatically

Hi

The usual solution for this is to concatenate the tables. It's not a problem that the fields are not identical - QV is very efficient with sparse tables.

Sell:

SQL SELECT

PK_AGENCY,

MONTHY,

PRODUCT,

TRANSACTION,

QUALITYSELL,

AMOUNT,

'QUALITY_SELL' As Source

FROM "DBM_MKT".dbo."QUALITY_SELL";

Concatenate(Sell)

SQL SELECT

PK_AGENCY,

MONTHY,

PRODUCT,

SUMVALUE,

'SELL_VALUE' As Source

FROM "DBM_MKT".dbo."SELL_VALUE";

You can select data from one or the other table using the Source field.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: Synthetic Keys not created automatically

Too many synthetic keys are probably not being allowed. How do you want the synthetic keys to be dealt with? Usually, you can rename them to avoid sythetic keys using preceding load, like:

.....

....

Load

PK_AGENCY as Q_Agency,

MONTHY as Q_Month,

PRODUCT as Q_product,

TRANSACTION,

QUALITYSELL,

AMOUNT ;

SQL SELECT

PK_AGENCY,

MONTHY,

PRODUCT,

TRANSACTION,

QUALITYSELL,

AMOUNT

FROM "DBM_MKT".dbo."QUALITY_SELL";

SQL SELECT

PK_AGENCY,

MONTHY,

PRODUCT,

SUMVALUE

FROM "DBM_MKT".dbo."SELL_VALUE";

Not applicable

Re: Synthetic Keys not created automatically

Same error message.

Community Browser