Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Meghann_MacDonald

Tracking Folder Structure with Onedrive Metadata

Hi all, I am using onedrive metadata to recreate my folderstructure. I started with this:

[tempFiles]:
LOAD name as [Items.name],
parentReference_path as [Items.parentReference_path],
folder_childCount as [Items.folder_childCount],
webUrl as [Items.webUrl];

SELECT name,
parentReference_path,
folder_childCount,
webUrl
FROM Items
WITH PROPERTIES (
driveId='',
folderId='',
path='/Nick',
maxResults=''
);

Which provides me with a list of the folder names within the first folder, "Nick". Great!

Now, based on that list, I want to have it look inside EACH folder and give me the names of THOSE files/folders. I think it would be basically the same code as above except with a "path" that is a variable, assigned to the file names from the table above. 

 

Additional info: this is what the code above gives me: 

Music.png

These "Item Names" are the names of subfolders. i then want to generate a list of the 4 folders within the Matthew_court_cmaj folder, and then the 3 folders within TalkTooMuchProject folder, and so on. 

Happy Holidays!

Labels (4)
0 Replies