Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
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;