Discussion Board for collaboration related to Creating Analytics for QlikView.
So I am currently trying to get following code working. When I execute it, I get a Script line Error. The code mentioned in the error starts at line 11. It probably is just a stupid mistage or misconseption as I am very new to this and have like no prgramming experience...
It would be nice, if someone can help me.
For counter_1=0 to 2
For counter=0 to 14
CUSTOM CONNECT TO $(URL);
FROM "customfield_10306" FK "__FK_customfield_10306" ArrayValueAlias "@Value"),
"@Value" AS "@Value_u0",
FROM "customfield_10305" FK "__FK_customfield_10305" ArrayValueAlias "@Value_u0")
FROM "fields" PK "__KEY_fields" FK "__FK_fields")
FROM "issues" PK "__KEY_issues" FK "__FK_issues")
FROM JSON (wrap on) "root" PK "__KEY_root";
[__FK_customfield_10306]&'.1' AS [__KEY_fields]
WHERE NOT IsNull([__FK_customfield_10306]);
[__FK_customfield_10305]&'.1' AS [__KEY_fields]
WHERE NOT IsNull([__FK_customfield_10305]);
[__KEY_fields]&'.1' as [__KEY_fields],
[__FK_fields]&'.1' AS [__KEY_issues]
[__KEY_issues]&'.1' as [__KEY_issues]
Drop Tables [RestConnectorMasterTable];
STORE [customfield_10306] INTO customfield_10306_$(SLA).qvd (qvd);
STORE [customfield_10305] INTO customfield_10305_$(SLA).qvd (qvd);
STORE [fields] INTO fields_$(SLA).qvd (qvd);
STORE [issues] INTO issues_$(SLA).qva
I had no time to fix this code, so I just did not loop the different URLs and put it in different tabs... But thanks for the help.
The Debugging did not help, as I see no error in my code. This apparently causes the error:
But even if the variables included are wrong, it should not give an script line error. I mean I only connect strings. It should give me an failed to connect later, if the URL is wrong.
Anyway, I have a solution that works, but it's just not as nice as this would have been.
difficult to identify just my guess
In variable URL_Intern_1 & URL_Extern_1. You are missing " which close your URL double quote (").
If it won't help run your script in debug -> step mode and check where you are getting error.
that is not the issue. I combine URL_Base & URL_1 & URL_2 which is the the actual URL. And the double quotes should be around that, not around each part.
I have a similar code working in another setup just fine, so it should be good. But thanks anyway.