Pivoting Query Issue ADX

ADX 156 Reputation points
2022-04-20T04:49:15.373+00:00

Hi

I have data in my table like below.

194531-image.png

after pivoting the data looks like

194477-image.png

I have build the query for this. But i want to check the date filter condition dynamically if there is no data for the given date it should return empty instead of error.

194464-image.png

I am passing the another Indate value where data is not exists in the table with that date.In that case its throwing an error mentioned below.

194420-image.png

I know the error is because no data in the table for the input date and we are selecting the Pivoted columns in the project. Can we do anything if no data exists for the given input date then it should not execute the statement lineno:6 i mean | project EventUTCDateTime,OPERATOR,PROFILE

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
504 questions
{count} votes