I am building a portal with definable column labels and definable row names, this works fine, my problem is my data is not formatted so I can assign in sequence to the correct column.
With ExecuteSQL I'm bringing back some distinct values from a table to be used as portal column labels, example
$$yLabels = Active Inactive Lost Won
With a second ExecuteSQL statement I am bring back some data in format, example
$yValues = Inactive|50 Won|75
I need to manipulate $yValues into the form below, place a 0 into every missing data point, following the same sequence as $$yLabels so I can assign the values to the correct portal field with my script. The loops all seem to be working correctly just need to get the raw data in the correct order.
$yValues2 = Active|0 Inactive|50 Lost|0 Won|75