Forum Discussion
Aarohi Chowdary
Jul 08, 2018Copper Contributor
Accessing a column from within toscalar() - Log Analytics Query Language
Speaking in terms of C, I need to do something like this: for(i = 0; i < 30; i++) subquery(i); The subquery returns a table with a single cell. I am trying to do something like this: ...
Noa Kuperberg
Microsoft
Jul 08, 2018not sure what you are trying to do, exactly.
in the given example, the input to the where clause is: "range index from 1 to 30 step 1", so the where clause can only recognize one column, named "index".
Can you explain a bit more what you want to do? is the repeating of subquery related to the index of each row?
- Aarohi ChowdaryJul 08, 2018Copper ContributorI 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()