Hi All,
I have multiple Google Sheet files (atm 20) stored in my Google Drive. Every few months a new file is created. Each Google Sheet file has an unique key wich can be used to acces the data. I have a QVD file with all the unique file keys and file names, dates ect. With the code below I am able to retreive the data from a specific file, just like I expect. I would like to store the data from all the files in a QVD at once. Is there a way to loop trough all the unique file keys, add the filename and filedate to the other data in the file and store it all in one QVD?
let vQwcConnectionName = 'lib://GoogleWebConnector';
GoogleDriveConnector_GetSheetValues:
LOAD
Column1 as GetSheetValues_Column1,
Column2 as GetSheetValues_Column2,
Column3 as GetSheetValues_Column3,
Column4 as GetSheetValues_Column4,
Column5 as GetSheetValues_Column5,
Column6 as GetSheetValues_Column6
FROM [$(vQwcConnectionName)]
(URL IS [http://localhost:5555/blablabla &spreadsheetKey=SPREADSHEET_KEY blablabla], qvx);
// Store GoogleDriveConnector_GetSheetValues into [lib://01.Extract/GetSheetValues.qvd]
Thank you very much in advance!
Kind regards,
Simon Kruizinga
