Discussion board where members can get started with QlikView.
I have a rather large table (5m+ rows) with unique folder locations e.g. C:\Windows\Tmp\30102014
I need to create another table with a row for every possible parent folder. So for the example above I would have 3 entries
I've tried looping through the tables, but it takes far too long.
Would there be a QlikView function for this which I am not thinking of?
Go to Solution.
You can use a LOAD with a WHILE clause:
Left(Folder,index(Folder,'\',iterno())-1) as Parent
LOAD * INLINE [
View solution in original post