Streamstats for multiple columns

[mbschriek]

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?

[mbschriek · Accepted solution]

Solved it myself:

 | foreach c* [eval <<FIELD>>='<<FIELD>>'+uPos-1] | makecontinuous uPos | filldown c* | foreach c* [eval <<FIELD>>=if(('<<FIELD>>'-uPos)>=0,"1","0")]

[woodcock]

Be sure to click Accept on your answer.