I have a CSV file with a column X containing "ID23857215326 anotherrandomtextaftertheid".
I only want to save the numeric ID as a real number during CSV ingestion.
How can this be done?
Kind regards
1 Answers
You can use an update policy:
- https://y0nil.github.io/kusto.blog/blog-posts/update-policies.html
- https://docs.microsoft.com/en-us/azure/data-explorer/kusto/management/updatepolicy
In your update policy query, you can use the "parse" operator: https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/parseoperator
Related