Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear team,
i have table box or straight table in my qlikview application.
i need to convert this chart data to json file format.
please help me on this.
find the attached for the sample.
Could you share the output format your excepting in qlikview ?? you could share the sample format or images etc
avinash,
required in below format.
{
"test": [{
"id": "500",
"program": "prog003",
"number": "333525",
"datetime": "2017-01-03 15:45:15",
"zone": "north",
"amount": "100"
}, {
"id": "501",
"program": "prog003",
"number": "333526",
"datetime": "2017-01-03 15:48:30",
"zone": "north",
"amount": "300"
}, {
"id": "502",
"program": "prog003",
"number": "333527",
"datetime": "2017-01-03 17:25:23",
"zone": "south",
"amount": "150"
}]
}
Thanks in advance
How much rows do you have in your straight table?
If there are not so much you could try rebuilding the straight table in textbox. (see attached file)
Another possibility, if you have a lot of rows, then you could use a converter (csvtojson)
After creating the CSV file with the STORE statement in script, you could use a script EXECUTE statement to run the CSV-JSON convertor .
hope this helps
hi,
my actual requirement is to send this straight table or table box data to extension object using javascript.
if you have something.
please share.
thanks in advance.