topic Script failed in QlikView

Script failed

Thu, 01 Aug 2013 15:34:25 GMT

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?

Re: Script failed

Thu, 01 Aug 2013 15:39:42 GMT

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...

Re: Script failed

Thu, 01 Aug 2013 17:28:27 GMT

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?

Re: Script failed

Thu, 01 Aug 2013 17:34:52 GMT

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