Loading data from Excel that has to match SQL data

Fri, 22 Jun 2012 15:54:29 GMT

Hi,

In blue below I have an SQL script that ONLY loads Projects that are Horizontal 'ABC'. I've reduced the script considerably for this example. In the red I have text that brings in projects from an Excel document. The problem is that it's bringing in ALL projects! It's cluttering up my QlikView dashboard list with irrelevant projects. How do I effectively say in the load script "Only bring in data from Excel corresponding to Projects that are found in the SQL database"

Thanks to anyone who has any suggestions

ODBC CONNECT TO ABC_Report;

SQL SELECT *

FROM Project.par.Projects

WHERE Status = 'Live'

AND Horizontal = 'ABC'

Project,

[Client (Summary)],

[Client Feedback],

FROM

(ooxml, embedded labels, table is Scorecard);

---------------------------------------------------------------------------------------------------------------

http://www.morrisongovan.co.ukMorrison Govan UK FATCA

Re: Loading data from Excel that has to match SQL data

fosuzuki — Thu, 28 Jun 2012 02:39:58 GMT

Lets say that in your DB, the Projects table has a field called ProjectName. And the Project field from the XLS is the project name. So:

SQL select ProjectName

from ....;

LOAD Project, ....

from xls....

where exists(ProjectName, Project);

The idea is to use the EXISTS() function, which will filter only the data from the XLS that already exists in the ProjectName.

Hope this helps you

Fernando

topic Re: Loading data from Excel that has to match SQL data in QlikView

Loading data from Excel that has to match SQL data

Re: Loading data from Excel that has to match SQL data