Speaking in terms of C, I need to do something like this:
for(i = 0; i < 30; i++)
The subquery returns a table with a single cell. I am trying to do something like this:
range offset from 1 to 30 step 1 | project Column = toscalar( range index from 1 to 30 step 1 | where index == offset)
But the offset in the toscalar() is not being recognized; I'm getting the following error: 'where' operator: Failed to resolve column or scalar expression named 'offset'. Is there an alternative to what I'm trying to do? Thanks in advance :)
PS: The sub-query in the toscalar() is actually the output of a very huge table; used range only for demonstration purpose.
I am trying to run the sub-query for each value of the range 1 to 30, and the sub-query results in a single cell table. The sub-query needs to have access to the current value from the range, but it isn't being recognized inside toscalar()