Discussion Board for collaboration on QlikView Scripting.
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:
WHERE SUAT LIKE 'AREA%';
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.
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.
'QUALITY_SELL' As Source
'SELL_VALUE' As Source
You can select data from one or the other table using the Source field.
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:
PK_AGENCY as Q_Agency,
MONTHY as Q_Month,
PRODUCT as Q_product,
Same error message.