The following table is representing positions in uPos for different columns. Each number in a c_ column is representing the number of positions are taken, starting at the position which the number is positioned.
For example:
The item in column c_A - 7 is representing reserved cells at uPos 7, 8, and 9.
The item in column c_F - 2 is representing reserved cells at uPos 2, 3, 4, and 5.
Goal:
I would like to fill all the reserved cells with a number to represent a nice bar chart.
Does anyone has an idea to solve this?
Solved it myself:
| foreach c* [eval <<FIELD>>='<<FIELD>>'+uPos-1] | makecontinuous uPos | filldown c* | foreach c* [eval <<FIELD>>=if(('<<FIELD>>'-uPos)>=0,"1","0")]
Solved it myself:
| foreach c* [eval <<FIELD>>='<<FIELD>>'+uPos-1] | makecontinuous uPos | filldown c* | foreach c* [eval <<FIELD>>=if(('<<FIELD>>'-uPos)>=0,"1","0")]
Be sure to click Accept
on your answer.