Forum Discussion
ramankr48
Helper II
Helper IIHow can I split a variable-depth, slash-delimited path_column field into separate col in KQL?
Q : How can I split a variable-depth, slash-delimited path_column field into separate path_lvl_1, path_lvl_2, … columns in Kusto (Fabric) so that Power BI (in DirectQuery mode) can consume a fixed sc...
Sure thing - just remove the column defintion fret the pivot function. Then the previous query will be dynamic
ramankr48Helper II
Helper III don't think it will work if no of values gets increased in the values column, will it be feasible or change the schema on the fly
datacoffee
Most Valuable Professional
Most Valuable ProfessionalSure thing - just remove the column defintion fret the pivot function. Then the previous query will be dynamic
- ramankr48
T
| extend ColSplit = split(values, "/")
| mv-expand ColIndex = range(0, array_length(ColSplit), 1)
| extend columnName = strcat("col", tostring(ColIndex + 1)), columnValue = ColSplit[ColIndex]
| evaluate pivot(columnName, any(columnValue))
| project-away ColSplit, ColIndex