load Multiple files from Google Drive into one QVD

[Channa]

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 · Accepted solution]

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);