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, 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!!!!!!!!!!!!!!!
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 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...
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, 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,
Multiple connections are already created in qliksense. I have those connection name in excelsheet(Connection.xlsx) like
ConnectionName
Connection1
Connecton2
Connection3
Now I n...
Hi there Experts, I have few excelsheet data that need to be used for my reporting. I loaded in Qlik Sense, but the issue I am having is getting the accurate results. sheet 1 O...
