Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mapratt82
New Contributor III

Working with both Excel and SQL

I have a Excel table loaded that I need to use, but I also need additional information from some different SQL tables. I originally just loaded the whole SQL tables, but now need to load just the lines related to the information in the Excel table. How would I do this?

3 Replies
karthickv
Contributor

Re: Working with both Excel and SQL

Hi Mark,

Your query is not clear. Can you post some samples ?

Though i am not 100% clear on your requirement, from my understanding i hope EXIST function might help you.

Regards,

Karthick V.

krishna_2644
Valued Contributor III

Re: Working with both Excel and SQL

Qlikview treats any load statement as a table irrespective of the datasource.

just follow the usual process and make sure you have the right data source at the right place in your script.

eg:

Table1:

Load A,B

from XYZtablefromSQL;

Table2:

Load C,D

from PQR.xls

Now qlikview treats two load statements as two different tables here.

you can perform joins and other techniques like the way you do on tables if they were all pulled from SQL.

Hope that helps.

Employee
Employee

Re: Working with both Excel and SQL

Maybe this

TableExcel:

Load Field1,Field2

from [lib://yourexcelfile];

TableSQL:

left keep // only keep rows connected by Field1

LOAD

     Field1,

     Field3;

SQL Select

     Field1,

     Field3

From yourtable;