Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm having some set of Excel files contains data, i need to load that Excel data into Qlikview by doing some filters using Api connector.
Give me some ideas
Thanks,
keke
Why do you need to connect to Excel files via an API connector? QlikView can read Excel files directly. You can also add filters using a WHERE clause.
For example:
LOAD Product,
Salesman,
Quantity
FROM
(biff, embedded labels, table is [Sample-spreadsheet-file$])
WHERE Quantity > 40000;
Iam having bunch of excel files for each year , instead of fetching data from DB i need to fetch from Excel , so for that i thought API connector may help
Then you can leverage the default "Excel File" ODBC connection to dynamically load multiple Excel files.
Check these articles:
Dynamically Loading Multiple Excel Files
Loading Multiple Excel Sheets Dynamically along with file name and sheet name
Hi,
Yes, you are correct but here my challenge is, there is no column name specification in excel file i need to find the column names using data from the excel so here which way i need to go.. Can you pls give me some idea to proceed
Thanks,
keke
I don't quite understand the requirements - does it means you need to load multiple Excel files, but don't know in advance how many columns and column names in each Excel file?
Some screenshots/ sample files may better clarify what you're trying to do.