Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to model/ingest paths as columns?

I am ingesting the output of a .ps1; which consist of folder paths + individuals with access:

 

 

Most of paths are as above:

Path1\path2\path3\path4\path5

 

But I have some that are:

Path1\path2\path3\path4\path5\path6\path7

 

(I also have an 8th and 9th column; which are: name and access).

 

If I use a matrix and display columns: Path1,path2,path3,path4,path5, name, access… I get a very nice visual.

 

But if I use path 6 and 7 too I get a lot of blanks and the matrix doesn’t work as expected.

 

Is my modelling wrong? How should I ingest/display paths as columns?