AnsweredAssumed Answered

Creating A Complete Data Set

Question asked by laguna92651 on Feb 24, 2018
Latest reply on Feb 26, 2018 by laguna92651

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

Outcomes