question

SQL-6436 avatar image
0 Votes"
SQL-6436 asked SQL-6436 commented

Pivoting Query Issue ADX

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
image.png (15.1 KiB)
image.png (5.5 KiB)
image.png (38.1 KiB)
image.png (38.6 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @SQL-6436,

We are reaching out to the internal team to get more details on this issue. I will be update you once I hear back from the team.

0 Votes 0 ·
SQL-6436 avatar image SQL-6436 PRADEEPCHEEKATLA-MSFT ·

Would be great if you have some inputs on this issue and suggest the same to me.

0 Votes 0 ·

0 Answers