Hello
I have an excel in the attachment
By seeing the spreadsheet. I created the json file (as restaurant_few.txt) on my own from scratch
But I have some problem with my "json file"
I have trouble with the header on top. For example:
For BBQ Pork Bun and it is in a merge cell.
Then the below two cells, one is sales volume, and the other is income.
How can I manipulate it. Please advice if there is any change for the "json file"
What's more Is my "json file" correct. if you see any problem or have any suggestion, please tell me
Thanks
The json code is at the bottom and also the attach text file
{
{"NO":1,
"SHOP": "Fanling",
"BBQ Pork Bun":[{
"Sales Volume": 20,
"Income": 100
}],
"Lotus Paste Bun":[{
"Sales Volume": 21,
"Income": 84
}],
"Sticky Rice":[{
"Sales Volume": 9,
"Income": 90
}]
},
{"NO":2,
"SHOP": "Sheung shui",
"BBQ Pork Bun":[{
"Sales Volume": 25,
"Income": 125
}],
"Lotus Paste Bun":[{
"Sales Volume": 15,
"Income": 60
}],
"Sticky Rice":[{
"Sales Volume": 9,
"Income": 80
}],
{"NO":3,
"SHOP": "Tuen mun",
"BBQ Pork Bun":[{
"Sales Volume": 27,
"Income": 135
}],
"Lotus Paste Bun":[{
"Sales Volume": 19,
"Income": 76
}],
"Sticky Rice":[{
"Sales Volume": 9,
"Income": 90
}]
},
{"NO":4,
"SHOP": "Tsuen wan",
"BBQ Pork Bun":[{
"Sales Volume": 21,
"Income": 105
}],
"Lotus Paste Bun":[{
"Sales Volume": 17,
"Income": 68
}],
"Sticky Rice":[{
"Sales Volume": 8,
"Income": 80
}]
},
{"NO":5,
"SHOP": "Kwun tong",
"BBQ Pork Bun":[{
"Sales Volume": 17,
"Income": 85
}],
"Lotus Paste Bun":[{
"Sales Volume": 20,
"Income": 80
}]
"Sticky Rice":[{
"Sales Volume": 10,
"Income": 100
}]
},
{NO:"n/a",
"SHOP":"TOTAL",
"BBQ Pork Bun":[{
"Sales Volume": 100,
"Income": 500
}],
"Lotus Paste Bun":[{
"Sales Volume": 92,
"Income": 368
}],
"Sticky Rice":[{
"Sales Volume": 44,
"Income": 440
}]
}
}
}
Bookmarks