topic Re: Api connector in QlikView

Api connector

keerthika — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Api connector

vunguyenq89 — Sat, 08 Sep 2018 10:24:48 GMT

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;

Re: Api connector

keerthika — Sat, 08 Sep 2018 10:35:55 GMT

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

Re: Api connector

vunguyenq89 — Sat, 08 Sep 2018 16:16:38 GMT

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

Re: Api connector

keerthika — Mon, 10 Sep 2018 13:05:59 GMT

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

Re: Api connector

vunguyenq89 — Tue, 11 Sep 2018 06:38:29 GMT

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.