Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Channa
Specialist III
Specialist III

load Multiple files from Google Drive into one QVD

HI All

i need to load All my CSV files into single QVD

* is not working with Google Drive 

i created one xls file with all file names and the i use below code

//////////////code/////////////

ListFiles:
LOAD
SNO,
trim("FileName") as FileName
FROM [lib://Downloads:Data/asdsadedfsd/6SenseFileNames.xlsx]
(ooxml, embedded labels, table is Sheet1) where not isnull(SNO);

 

for i = 0 to FieldValueCount('FileName')-1;

LET vFileName = Peek('FileName',i,'$(ListFiles)');

'$(vFileName)':
load *
FROM [lib://Downloads:Data/asdsadedfsd/$(vFileName)]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);
DROP Table '$(vFileName)';
Next i;

it is not working with out that drop and need help to move all files into QVD

Channa
Labels (2)
1 Solution

Accepted Solutions
Channa
Specialist III
Specialist III
Author

i has solution

// ListFiles:
// LOAD
// SNO,
// trim("FileName") as FileName
// FROM [lib://Downloads:Data/0AL_dmdEGAnXCUk9PVA/6SenseFileNames.xlsx]
// (ooxml, embedded labels, table is Sheet1) where not isnull(SNO);

 


// for Each file_name in FieldValueList('FileName');
// //Qualify *; // making sure field names are unique to aviod synthetic keys
// Final:
// LOAD
// *,FileName() as Fname
// FROM [lib://Downloads:Data/0AL_dmdEGAnXCUk9PVA/$(file_name)]
// (txt, codepage is 28591, embedded labels, delimiter is ',', msq);
// next;

// store Final into [lib://Downloads:Data/0AL_dmdEGAnXCUk9PVA/Sense.qvd](qvd);

Channa

View solution in original post

1 Reply
Channa
Specialist III
Specialist III
Author

i has solution

// ListFiles:
// LOAD
// SNO,
// trim("FileName") as FileName
// FROM [lib://Downloads:Data/0AL_dmdEGAnXCUk9PVA/6SenseFileNames.xlsx]
// (ooxml, embedded labels, table is Sheet1) where not isnull(SNO);

 


// for Each file_name in FieldValueList('FileName');
// //Qualify *; // making sure field names are unique to aviod synthetic keys
// Final:
// LOAD
// *,FileName() as Fname
// FROM [lib://Downloads:Data/0AL_dmdEGAnXCUk9PVA/$(file_name)]
// (txt, codepage is 28591, embedded labels, delimiter is ',', msq);
// next;

// store Final into [lib://Downloads:Data/0AL_dmdEGAnXCUk9PVA/Sense.qvd](qvd);

Channa