How to cast a column in ADX

Axel 1

I have a Table with two columns, values_1 and values_2, which are float:s. Is there a command in adx to cast these to ints in a simple way or do I need to do:

Table
| extend values_1 = toint(value_1)
| extend values_2 = toint(value_2)

to get these as int:s?

HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2021-09-29T16:44:32.897+00:00

Hello @Axel ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2021-10-05T18:43:05.97+00:00

Hello @Axel ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
Axel 1 Reputation point

2021-10-06T07:16:27.867+00:00

Hi, thank you for taking your time to help but the answer you provided was essentially what was written in my question, so did not provide any direct solution.
It is not really a problem, since I had a "solution" in my question, but more wondering how to write some things more neatly.

But the specific question is: is there a simple function to just cast a column in a table to int inplace without using extend, as in my example?

1 answer

HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2021-09-22T19:37:05.52+00:00
Hello @Axel ,
Thanks for the ask and using Microsoft Q&A platform .
You can use toint()

AzureMetrics
| project Average,toint(Average)

Please do let me know how it goes .
Thanks
Himanshu

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

How to cast a column in ADX

1 answer