Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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