Hi All, The script below loads the data into qlikview file for multiplesheets in a single load by using the Loop statements. LET vStartSheetNumber = 1; LET vEndSheetNumber = 50; LET v...
Hi All, This document helps you in loading multipleexcels and excelsheets with the name of the sheet and data. //to read each file from the specified folder FOR EACH file in FileList('f...
Hi all beloved Qlikers, I will get monthly Excel reports which contain more than 10 sheets. Is there anyways to load all sheets in 1 script? The problem here is there is no header from Sheet 2 o...
...ithin 5 sheets i every excel file.
Is there any option to do this LOAD ?
LIB CONNECT TO 'DA_CONNECTORS:SHP_metadata'; List_of_SASPRICELIST_FILES: LOAD UniqueId 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....
Hi, I need to load all the sheets from an excel file. In qlikview we use ODBC to connect excel But in Qlik sense i am not able to do that . Attached a sample file for my requirement. Help Please!!!!!!!!!!!!!!!
Hello everyone,
I have a requirement that need to load the table from Excel.
my excel contains two sheets, 1) Sales 2)Department.
my requirement is to write a single script, to load t...
Hi I want to load data from multipleexcelfiles that can containe multiple worksheet. I have made a Excel file that contains the name of the files, the worksheet and the path where it is placed. I m...
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...
