Read different Google Spreadsheets, through a loop that will get the GSS id's from an Excel File
Hi:
I have different google spreadsheets that I want to load in a Qlik Sense APP to create one table, they all have the same structure and fields, but different values.
So I was thinking creating an excel file, with all the ids in one column, and then loading all the google spreasheets that are listed in that column, by id, one at a time, concatenating them in one table.
How could I achieve that ? I already have configured the connection to be able to read GSS by id's, I only need the loop structure.