path file parent child

Hi koorosh , yes you can achieve this using power query editor , follow below steps :

Step 1) Open the power query editor and duplicate the Path Column by right clicking on the column :

Step 2) Right click on the duplicated column and select split column by delimiter :

Step 3) Then you can remove the below highlighted column :

Step 4) now for the first splitted column, you can replace the blank value with 'root' as shown below :

This will give you the expected result.

let me know if this works for you else share the additional details for your requirement.

Thanks,

Ankita