Forum Discussion
Trying to expand a json array into multiple columns
Hi adamcodes716,
Thanks for using Fabric Community.
You will need to do this KQL Queryset with 2 lines of code: mv-expand operator and bag_unpack() in KQL language. You can put these inside a function and call this function from Update Policies to transform this data on the fly.
Docs to refer -
mv-expand operator - Azure Data Explorer & Real-Time Analytics | Microsoft Learn
bag_unpack plugin - Azure Data Explorer & Real-Time Analytics | Microsoft Learn
Hope this is helpful. Please let me know incase of further queries.
Hi adamcodes716 ,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .
Thanks
Hi adamcodes716 ,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .
Thanks
Hi adamcodes716 ,
Glad to know that your query got resolved. Please continue using Fabric Community on your further queries.