Working with both Excel and SQL

[mapratt82]

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?

[karthickv]

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]

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.

[Clever_Anjos]

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;