Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
max_potass
Creator
Creator

Script Line Error. Can't find my mistake

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.

Let URL_Base='something';

Let Timeout='something';

Let URL_Open_1='something';

Let URL_Open_2='something';

Let URL_Intern_1='something';

Let URL_Intern_2='something';

Let URL_Extern_1='something';

Let URL_Extern_2='something';

For counter_1=0 to 2

  Let URL_1=$(URL_Base)&IF($(counter_1)=0,$(URL_Open_1),IF($(counter_1)=1,$(URL_Intern_1),$(URL_Extern_1)));

  Let URL_2=$(Timeout)&IF($(counter_1)=0,$(URL_Open_2),IF($(counter_2)=1,$(URL_Intern_2),$(URL_Extern_2)));

  For counter=0 to 14

  Let URL=$(URL_1)&($(counter)*1000)&$(URL_2);

  CUSTOM CONNECT TO $(URL);

  RestConnectorMasterTable:

  SQL SELECT

  "__KEY_root",

  (SELECT

            "key",

              "__KEY_issues",

            "__FK_issues",

              (SELECT

                    "created",

                    "__KEY_fields",

                    "__FK_fields",

                    (SELECT

                    "@Value",

                        "__FK_customfield_10306"

                    FROM "customfield_10306" FK "__FK_customfield_10306" ArrayValueAlias "@Value"),

                    (SELECT

                        "@Value" AS "@Value_u0",

                        "__FK_customfield_10305"

                    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";

  [customfield_10306]:

  LOAD   [@Value],

        [__FK_customfield_10306]&'.1' AS [__KEY_fields]

  RESIDENT RestConnectorMasterTable

  WHERE NOT IsNull([__FK_customfield_10306]);

  [customfield_10305]:

  LOAD   [@Value_u0],

        [__FK_customfield_10305]&'.1' AS [__KEY_fields]

  RESIDENT RestConnectorMasterTable

  WHERE NOT IsNull([__FK_customfield_10305]);

  [fields]:

  LOAD [created],

        [__KEY_fields]&'.1' as [__KEY_fields],

        [__FK_fields]&'.1' AS [__KEY_issues]

  RESIDENT RestConnectorMasterTable;

  [issues]:

  LOAD   [key],

        [__KEY_issues]&'.1' as [__KEY_issues]

  RESIDENT RestConnectorMasterTable;

  Drop Tables [RestConnectorMasterTable];

  Let counter=$(counter)+1;

  next

Set counter=0;

Let SLA=If($(counter_1)=0,'open',If($(counter_1)=1,'intern','extern'));

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

1 Solution

Accepted Solutions
max_potass
Creator
Creator
Author

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:

Let URL_1=$(URL_Base)&IF($(counter_1)=0,$(URL_Open_1),IF($(counter_1)=1,$(URL_Intern_1),$(URL_Extern_1)));

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.

View solution in original post

15 Replies
vishsaggi
Champion III
Champion III

Can you screen shot that script error you are getting?

dan_sullivan
Creator II
Creator II

Is there more after line 67?  if not make sure you have  semi-colon there at the end.

tamilarasu
Champion
Champion

Hi Max,

I could see two "FOR" loops in your script but only one "Next" statement. Could you try again by adding "Next" statement in the above script?

max_potass
Creator
Creator
Author

I attached the file. Just noticed, that the script line error includes my whole script, not only one tab.

max_potass
Creator
Creator
Author

There is. See answer to vishsaggi. I attached the whole file.

max_potass
Creator
Creator
Author

There is a second next. Forgot to copy that apperently. See answer to vishsaggi. I attached the whole file.

max_potass
Creator
Creator
Author

Oh, and there is no ';' after the next, but I tried it, and it did not work. It gave me more errors. Maybe I did something wrong.

PrashantSangle

Hi,

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.

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
max_potass
Creator
Creator
Author

Hi,

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.