Load User Defined Function from Script

nigel987 — Tue, 14 Mar 2017 13:16:24 GMT

Hi,

I have a user defined function called GetPayLoad, which I defined in Tools -> Edit Module.

function GetPayLoad(jsonString, fieldName) {

if (jsonString) {

var json = eval('('+jsonString+')');

if (json.hasOwnProperty(fieldName)) {

return json[fieldName];

}

return null;

}

It works as expected.

Now I would like to export it to a text file so that I can reuse it in other applications. Therefore I exported the function to a txt file, inserted an include command in the script and tried to use the function during load.

RemoteTable:

LOAD

ad_uuid,

GetPayLoad(payload_json, 'fromMail') AS fromMail;

SQL SELECT

ad_uuid,

toJson(payload) AS payload_json

FROM ...;

Now I get the error

Unknown statement

function GetPayLoad(jsonString, fieldName) {

if (jsonString) {

var json = eval('('+jsonString+')')

Can anyone help me with that? Do I need to call the function separately somehow?

Thanks! Nihal

Re: Load User Defined Function from Script

avinashelite — Tue, 14 Mar 2017 13:38:07 GMT

As per my knowledge the Macro code has to be in the Macro edit window

Qlikview edit script has the ability to call the function but you cannot have the macro code in the QV edit script

Paste the code in the macro editor and then try

topic Load User Defined Function from Script in QlikView

Load User Defined Function from Script

Re: Load User Defined Function from Script