Loading Multiple Local JSON Files

[chrisbaylis]

Hello,

I have multiple JSON files that I need to load into Qlik Sense. I am able to load one JSON file successfully but get an error when attempting to load multiple.  Is there a way to get around this, or am i approaching this the wrong way?

Script to load multiple files with similar name:

LOAD
Date("ReportedDate" ,'DD/MM/YYYY') AS [Date],
ChannelType,
ID
From [lib://Qlik Staging Folder/GetCorrelation*.json]
(json, codepage is 1525, embedded labels);

[tush]

Hi ,

         You can find an extension at Branch.qlik.com named Restore and Backup , you can make backup of your both qvf in json and then with the help of script editor merge the two JSON file and then create an new application and restore it. I am doing R&D on it , You may also try at your end , if there is any JSON developer or who knows JSON basic.

Thanks

Tushar

[chrisbaylis]

Thanks for the suggestion Tushar.

Unfortunately its not just two JSON files, there are many files and this number will increase daily. 

[tush]

Hi,

     i don't know the solution will work or not but you can try it.

whatever the json object file coming from server you can stored it in single folder on run time

so on loading the data you can use * instead of the particular JSON object file.

Thanks

Tushar