topic Re: Error in arithmetic operation in script load editor in Connectivity & Data Prep

Error in arithmetic operation in script load editor

LeonardoB25 — Mon, 18 Sep 2023 13:15:06 GMT

Hello, this is a snippet of my script load editor:

I have the error "unexpected token" at line 68, the [Data Documento] on the right is the problem. Compiler expects an operator, a ':' or a ','. I really don't understand why it's wrong, since syntax seems correct from what i saw online.

Here the error log:

Re: Error in arithmetic operation in script load editor

fachto76 — Mon, 18 Sep 2023 13:38:54 GMT

Hi , you can't define [Data Documento] twice.

[Data Documento], $(AgeofMostRecentDate) AS [Data Documento2] should work

Re: Error in arithmetic operation in script load editor

marcus_sommer — Mon, 18 Sep 2023 13:50:53 GMT

Your age-variable assignment is wrong and results in NULL which removed the variable. Reason is your attempt to access maxdata. In general no values could be accessed on the outside of load-statements unless using functions like peek() or fieldvalue() and so your variable-creation may look like:

let var = fieldvalue('fieldname', 1);

Re: Error in arithmetic operation in script load editor

LeonardoB25 — Mon, 18 Sep 2023 14:26:59 GMT

hello. Thanks for your reply. Unfortuntely, I already tried some different names on the right of the AS, such as [Nuova Data Documento] (which means new document date), but I got the same problem.

Re: Error in arithmetic operation in script load editor

LeonardoB25 — Mon, 18 Sep 2023 14:31:52 GMT

Hello, thanks for your reply. From what I can see from documentation, it appears that fieldvalue with 1 accesses the first element in the loading order of that field. I don't understand how can this solve a problem. Does it fetch the biggest (most recent) date in that field even from outside the load statement?

Re: Error in arithmetic operation in script load editor

marcus_sommer — Mon, 18 Sep 2023 14:58:06 GMT

The field-value access per peek() and fieldvalue() is only on a defined index - but the table-records and/or field-values could be loaded in a certain order which makes a sensible access possible - especially if the first and/or last values are the wanted ones.

In regard to your case I referred to maxdata which you creates the step before and this table has just a single record and therefore the access per:

let var = fieldvalue('fieldname', 1);

or alternatively

let var = peek('fieldname', 0, 'tablename');

will work.

Re: Error in arithmetic operation in script load editor

LeonardoB25 — Mon, 18 Sep 2023 17:00:29 GMT

Thanks for your reply. Unfortunately, the error persists the same even after i changed the variable declaration as you said. ("unexpected token: [Nuova Data Documento]")

Re: Error in arithmetic operation in script load editor

marcus_sommer — Tue, 19 Sep 2023 05:48:54 GMT

My examples were with var/fieldname/tablename just generic - you need to apply the existing ones.

Re: Error in arithmetic operation in script load editor

LeonardoB25 — Tue, 19 Sep 2023 10:57:06 GMT

sorry I'm stupid as hell. Will try now.

Re: Error in arithmetic operation in script load editor

LeonardoB25 — Tue, 19 Sep 2023 11:03:18 GMT

unfortunately, the exactly same error persists even after your suggestions. I really don't know what could be the problem at this point

thank you anyway

Re: Error in arithmetic operation in script load editor

marcus_sommer — Tue, 19 Sep 2023 11:12:10 GMT

It's the syntax - "normal" fields and tables will be specified with: Fieldname respective wrapped with certain quotes like "" or [] if the field-names contain any spaces or special chars. But by using field-functions it's different because they require a string-representation for the field and therefore single-quotes, like (above already shown):

let var = fieldvalue('fieldname', 1);

Re: Error in arithmetic operation in script load editor

LeonardoB25 — Tue, 19 Sep 2023 13:32:58 GMT

you're right, it was my fault from the beginning. Thanks again!