Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Synthetic keys with large data can cause the issue. Try to reload with Debug mode -> Limited load, does the issue persist?
It doesn't help. The issue remains. Thanks
Loading single table?
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.
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.
I tried to load each table alone and it is okay, the problem is when I load QUALITY_SELL and SELL_VALUE together.
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
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";
Same error message.