Load data from multiple google sheet files

[Simon_Kruizinga]

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

[Simon_Kruizinga · Accepted solution]

Never mind....

It cost me a couple of hours but I have found the solution myself 😁

I have used the for...next statement

[JuMo]

Hello

Could you please put an exemple of how is your script after correction ?

Many thanks