Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);