I have a JSON file that looks like this:
[
{
"State": "Alabama",
"Specialty": "Specialty 1",
"Cat1": "$xxx,xxx",
"Cat2": "$xxx,xxx",
"Cat3": "$xxx,xxx"
},
{
"State": "Alabama",
"Specialty": "Specialty 2",
"Cat1": "$xxx,xxx",
"Cat2": "$xxx,xxx",
"Cat3": "$xxx,xxx"
},
{
"State": "Alabama",
"Specialty": "Specialty 3",
"Cat1": "$xxx,xxx",
"Cat2": "$xxx,xxx",
"Cat3": "$xxx,xxx"
},
{
"State": "Alaska",
"Specialty": "Specialty 1",
"Cat1": "$xxx,xxx",
"Cat2": "$xxx,xxx",
"Cat3": "$xxx,xxx"
},
{
"State": "Alaska",
"Specialty": "Specialty 2",
"Cat1": "$xxx,xxx",
"Cat2": "$xxx,xxx",
"Cat3": "$xxx,xxx"
},
{
"State": "Alaska",
"Specialty": "Specialty 3",
"Cat1": "$xxx,xxx",
"Cat2": "$xxx,xxx",
"Cat3": "$xxx,xxx"
},
{
"State": "Arkansas",
"Specialty": "Specialty 1",
"Cat1": "$xxx,xxx",
"Cat2": "$xxx,xxx",
"Cat3": "$xxx,xxx"
},
{
"State": "Arkansas",
"Specialty": "Specialty 2",
"Cat1": "$xxx,xxx",
"Cat2": "$xxx,xxx",
"Cat3": "$xxx,xxx"
},
{
"State": "Arkansas",
"Specialty": "Specialty 3",
"Cat1": "$xxx,xxx",
"Cat2": "$xxx,xxx",
"Cat3": "$xxx,xxx"
}
]
I want to use this JSON file display the 3 category values, based on 2 user select dropdowns (State and specialty). This JSON file will be edited somewhat frequently via CSV and converted to JSON which will be formatted in this way which is the biggest obstacle I have in trying to complete this. I can search JSON trees in other formats, but this one has given me some issues. Any idea what the easiest way to go about this is?
