You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Above results in adding columns, but Values are still displayed as ["Value"] and not Value
Is there a better way to do this. How can I bring the value out of [""]
If the string had more keys or source string was dynamic in nature , is there a way to dynamically create columns. Seems like bag_unpack does it but I cannot use those in query such as filtering with where.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I want to extend DetectionMethods which is string data type in emailevents table. But this may apply to other tables and situations,
EmailEvents | take 1000 | extend kqlt=parse_json(DetectionMethods) | extend DM_Phish=kqlt.Phish, DM_Spam=kqlt.Spam
Above results in adding columns, but Values are still displayed as ["Value"] and not Value
Is there a better way to do this. How can I bring the value out of [""]
If the string had more keys or source string was dynamic in nature , is there a way to dynamically create columns. Seems like bag_unpack does it but I cannot use those in query such as filtering with where.
Thanks
{"Phish":["Spoof external domain"],"Spam":["Mixed analysis detection"]}
Beta Was this translation helpful? Give feedback.
All reactions