topic QlikView Script: Exporting Data Issue in QlikView

QlikView Script: Exporting Data Issue

Foodie123 — Thu, 07 Sep 2023 14:12:24 GMT

Hello,

I am trying to have my script export data, seen in the 4th attachment, but nothing is being exported and I'm not sure why.

Any help is appreciated.

Re: QlikView Script: Exporting Data Issue

Oleg_Troyansky — Thu, 07 Sep 2023 14:16:42 GMT

Hi there!

I noticed an "Exit Script" statement at the end of screenshot 3. Nothing will be performed after that. You should remove that statement if you want the rest of your script to be performed.

To learn more advanced development techniques, check out the agenda of the Masters Summit for Qlik - coming soon to Orlando and to Dublin!

Re: QlikView Script: Exporting Data Issue

Foodie123 — Thu, 07 Sep 2023 15:00:07 GMT

Hello Oleg,

I removed the exit script but nothing is still being exported.

Now I am getting an error saying the field Total_Loss_Cost is not found.

Re: QlikView Script: Exporting Data Issue

Oleg_Troyansky — Thu, 07 Sep 2023 15:10:32 GMT

Now you should go through your load script log and find out how many rows are loaded in each table and where your logic might be breaking. The problem is not in the exporting part, but in the load and transformations.

It's impossible to troubleshoot your script based on 4 pictures, you'll have to do it on your end.

Cheers,