Script failed

[#1]

It happens loading LOTs of data from qvds. No error, no nothing, it fails.

It creates me a synthetic1, synthetic2, and then a synthetic3 (synthetic1+synthetic2)

Could be that the problem? Dont know how to solve that without creating a circular relation.

Qlikview has a limit of loading date?

Thanks. Any help?

[#2]

I assume as it is creating a lot of synthetic keys and then circular loops, the data is multiplied in a very high number then eventually the load fails. Put the where clause condition and test it with a sub set and handle your synthetic keys and loops and then run the full load...

[#3]

mmm basically i create from 2 databases same qvds (sellers,customers, etc)

and then, in another qlikview document, i call both qvds named sellers.

if anyone can help me to solve that synthetic key without creating a circular relationship (i dont have it now). because i think thats the problem of scritp failed..

what would be the code to solve the synthetic if i had something like this

So it creates synthetic key 1 = cust, seller, art

synthetic key 2 = art, stock

synthetic 3 = synthetyc 1 + 2

Any help?

[#4]

If customer and seller are the same then you should append the data in one qvd or one table in qvw.. just think how would you solve this issue in a database or an other BI tool first ....qlikview is no different ... it just want the unique column names