I have data in my table like below.
after pivoting the data looks like
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.
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.
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