Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

General script error

Hello,

I have a 'General script error', but I don't know why.

It does not show me any error, just that the reload is finished and it's asking me if I want to reload the old data.

This is the end of the script :

20150805 16:38:32: 1532  LOAD

20150805 16:38:32: 1533   if([Supplier Pyramid ID]=[Supplier Global Ultimate Single ID],[Supplier Total Turnover]) as [Supplier Total Turnover],

20150805 16:38:32: 1534   if([Supplier Pyramid ID]=[Supplier Global Ultimate Single ID],[Supplier TurnOver Declaration Year]) as [Supplier TurnOver Declaration Year],

20150805 16:38:32: 1535 

20150805 16:38:32: 1536   [Supplier Pyramid ID] as [GUO Pyramid ID],

20150805 16:38:32: 1537   [Supplier Global Ultimate Single ID]

20150805 16:38:32: 1538  resident  SUPPLIER_GROUPS

20150805 16:38:32:       4 fields found: Supplier Total Turnover, Supplier TurnOver Declaration Year, GUO Pyramid ID, Supplier Global Ultimate Single ID, 212.746 lines fetched

20150805 16:38:32: 1539  left join

20150805 16:38:32: 1540  LOAD

20150805 16:38:32: 1541   [Supplier Pyramid ID],

20150805 16:38:32: 1542   SupplierKey

20150805 16:38:32: 1543  resident SUPPLIERS

20150805 16:38:32:       2 fields found: Supplier Pyramid ID, SupplierKey, 353.688 lines fetched

20150805 16:38:33:       Joining/Keeping

20150805 17:04:23:       General Script Error

20150805 17:08:18:       Execution Failed

Do you have any idea why is this happening ?

Thanks!

1 Solution

Accepted Solutions
Master III
Master III

I think

the line is changing the key fieild to something [Supplier Pyramid ID] as [GUO Pyramid ID]  ?

I do not see [Supplier Pyramid ID] in the log

4 fields found: Supplier Total Turnover, Supplier TurnOver Declaration Year, GUO Pyramid ID, Supplier Global Ultimate Single ID, 212.746 lines fetched

HTH

Sasi

View solution in original post

4 Replies

Can you share your script for the portion near the failure?

Master III
Master III

I think

the line is changing the key fieild to something [Supplier Pyramid ID] as [GUO Pyramid ID]  ?

I do not see [Supplier Pyramid ID] in the log

4 fields found: Supplier Total Turnover, Supplier TurnOver Declaration Year, GUO Pyramid ID, Supplier Global Ultimate Single ID, 212.746 lines fetched

HTH

Sasi

View solution in original post

Not applicable

Yes. That was the problem. Thank you very much !