Hi, everyone. I have a question that needs to be solved.
Qlik Sense version: Qlik Sense August 2021
Qlik Sense Server: 14.28.3
My situation is to load multipleExcel files with different sheet...
Hi All, I recently asked a question about concatenating multiplesheets in the same Excel spreadsheet. There is no sequential/logical filename and i have been provided with a few ways to do it u...
Hi community, I am trying to connect to Excel to load multiplesheets and get the sheet name. I want to use the sqltables function to do that. That is why I am using a connection and not l...
Hello All,
I am trying to load data from multiplesheets from single excel file and store each sheet into QVD dynamically.
i am using below code
FOR EACH file in FileList('l...
Hello,
we are moving from Qv to QS, and we have found another issue: we are reading sheets from different Excel files. We don't know the number of sheets or their names, so we are using this p...
Hi Team, The attached excel file contains multiplesheets. 1.eSol 2.Data for Field1 3.Data for Field2 4.Data for Field3 5.Data for Field4 My Requirement is my script should load o...
Hello, I have multipleExcel files in a folder and each has several sheets. The table structure for each file and sheet is the same. I am trying to run a loop so that all the data is input and a...
Hi experts, I need to load all data in multipleexcelsheet without mentioning the sheet name in the script. anyone please guide me t complete this task. i have attached the sample data....
Boa tarde comunidade, Tenho o seguinte problema: Tem varias planilhas em excel,e de cada uma quero buscar a informação contida na primeira linha, porém estou conseguindo buscar somente da p...
