Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

14 Replies
tresesco
MVP
MVP

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

Not applicable
Author

It doesn't help. The issue remains. Thanks

tresesco
MVP
MVP

Loading single table?

Not applicable
Author

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.

tresesco
MVP
MVP

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
Author

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

jonathandienst
Partner - Champion III
Partner - Champion III

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
tresesco
MVP
MVP

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
Author

Same error message.