I am facing some issues with the make_string function. The following command print str = make_string(75, 117, 115, 116, 111) returns "Kusto" as expected, but it is not possible to use this function in the datatable scope. The following kql: datatable (Input: string) [ make_string(75, 117, 115, 116, 111) ] returns error message: Syntax Error A recognition error occurred. Token: make_string Line: 2, Position: 4 Do you have any idea, why it does not work?

Hello anonymous user , Thanks for the question and using MS Q&A platform. As per the documentation - datatable operator , the datatable operator only accepts scalar values. Hope this will help. Please let us know if any further queries. ------------------------------ 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

KQL using make_string() function in datatable[] scope

Accepted answer

PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2022-04-18T08:48:12.423+00:00
Hello anonymous user,

Thanks for the question and using MS Q&A platform.

As per the documentation - datatable operator , the datatable operator only accepts scalar values.

Hope this will help. Please let us know if any further queries.

------------------------------

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.
Anonymous

2022-04-19T08:30:15.607+00:00

Hello @PRADEEPCHEEKATLA-MSFT

thanks for the answer.

I've checked using the toscalar() function, but it is not successful as well:

let str = toscalar(make_string(75, 117, 115, 116, 111)); datatable (Input: string) [ str ]

In this case, the str variable is scalar, but the same error message occurs...

Please loot, the the following examples:

datatable (Input: datetime) [ datetime(2022,04,12) ] datatable (Input: datetime) [ make_datetime(2022,04,12) ]

The first command works, but the second does not. Please note, the documentation of make-datetime. There is a note:

Creates a datetime scalar value from the specified date and time.

The make-datetime() function is listed on the scalar functions as well, so the input condition for datatable scope is met.

So, I am a bit confused and have some doubts regarding restrictions for scalar values and datatable scope.

PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2022-04-20T13:59:50.373+00:00

Hello anonymous user,

datatable operator does not perform any evaluations (e.g., function calls). Potential solution is to have a static table with test content for comparison.

You may try the below workaround:

datatable (Input: dynamic) [ dynamic([75, 117, 115, 116, 111]) ] | extend Input = make_string(Input)

PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2022-04-25T05:17:55.503+00:00

Hello anonymous user,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Sign in to comment

KQL using make_string() function in datatable[] scope

0 additional answers