How can I execute a user defined function in Kusto which includes toscalar() on every row of my table?

edit

You can use the mv-apply operator to apply your user-defined function to every row of your table, and then use the toscalar() function to convert the resulting array back to a scalar value. Here's an example:

Suppose you have a table called MyTable with columns Col1 and Col2, and you want to apply a user-defined function myFunction() to every row of this table. Here's how you can do it:

MyTable
| mv-apply myFunction() on (Col1, Col2)
| extend Result = toscalar(Result)

The mv-apply operator applies myFunction() to every row of the table, using the values in columns Col1 and Col2 as arguments. This will create a new column called Result which contains an array with the results of the function for each row.

The extend operator is then used to create a new column called Result which contains the scalar value in the Result array. The toscalar() function is used here to convert the array to a scalar value.

Note that you'll need to modify the mv-apply expression to match your specific user-defined function and table columns.