Hello,
I have an issue which I have trouble getting past.
I have filtered out a 'shipment' from an array with multiple shipments and I have the following array which is with my values I want to use further:
[
{
"ShipmentNumber": "1005",
"Analysis1": 23,
"Analysis2": 135655,
"Analysis3": null,
"Analysis4": 0,
"Analysis5": "10",
"Analysis6": "7",
"FlourPERC": 0.1,
"FlourProducedFrom": "zone 2, zone 4, zone 5",
"MilkPerc": 0.2,
"MilkProducedFrom": "zone 44,zone 45, zone 46, zone 47",
"YeastPerc": 0.2,
"YeastProducedFrom": "Zone 1, Zone 2, Zone 4",
"WheatPERC": 95.5,
"WheatProducedFrom": "Zone 10 , Zone 12",
}
]
What I would like is to append the following information into an array variable with the following three variables listed down below. Since these values are not constant, and there is a different composition for each product, which I would to avoid making different flows for each composition.
1. Product names, I.e "WheatPerc" without Perc.
2. The percentage of product in the end product. The value from FlourPerc, WheatPerc etc, ie value from all variables containing 'Perc'.
3. The values from all variables containing 'ProducedFrom'.
The rest of the values above "FlourPerc" are constant and not relevant, like shipmentnumber, analysis data etc.
I'm quite stuck, and can't seem to see how I can append the values I want in a good way. I've looked at something like this:
But it's appending the values containing the differnt values that are an issue.
Any help would be highly apriciated!
Edit: Typo.
