topic Direct Discovery INVOICE DATA in QlikView https://community.qlik.com/t5/QlikView/Direct-Discovery-INVOICE-DATA/m-p/735747#M263269 <HTML><HEAD></HEAD><BODY><P>I have built a QlikView QVD file for tracking Invoice data.&nbsp; I utilize a SQL server database for the data source.&nbsp; I link-in multiple tables/fields with a single pull with multiple joins for (i.e. ROLODEX, CUSTOMER, ACCOUNT, ITEMS, INVOICE,…) .&nbsp; I am trying to convert this to live access to the SQL server data source using Direct Discovery to get up-to-the-minute data when need.&nbsp; If I take the SQL script I have created which utilizes the aliases of the tables and the joins it fails noting it cannot find the source/field identified (i.e. CUSTOMER.name, ACCOUNT.number, INVOIVE.date…).&nbsp; Looking at ‘QlikView 11.2 SR7 Direct Discovery.pdf’ some of the example show that it is possible to define the datasource.schema.table.field with joins in place.&nbsp; Tried to do this and also fails to load.&nbsp; When I create a single data source and not include the table name the load works fine.&nbsp; Is it that Joins of multiple tables cannot be accomplished and the tables must be built separately and joined after they are built to achieve the necessary results?</P></BODY></HTML> Wed, 15 Oct 2014 19:36:43 GMT bjsellers57 2014-10-15T19:36:43Z Direct Discovery INVOICE DATA https://community.qlik.com/t5/QlikView/Direct-Discovery-INVOICE-DATA/m-p/735747#M263269 <HTML><HEAD></HEAD><BODY><P>I have built a QlikView QVD file for tracking Invoice data.&nbsp; I utilize a SQL server database for the data source.&nbsp; I link-in multiple tables/fields with a single pull with multiple joins for (i.e. ROLODEX, CUSTOMER, ACCOUNT, ITEMS, INVOICE,…) .&nbsp; I am trying to convert this to live access to the SQL server data source using Direct Discovery to get up-to-the-minute data when need.&nbsp; If I take the SQL script I have created which utilizes the aliases of the tables and the joins it fails noting it cannot find the source/field identified (i.e. CUSTOMER.name, ACCOUNT.number, INVOIVE.date…).&nbsp; Looking at ‘QlikView 11.2 SR7 Direct Discovery.pdf’ some of the example show that it is possible to define the datasource.schema.table.field with joins in place.&nbsp; Tried to do this and also fails to load.&nbsp; When I create a single data source and not include the table name the load works fine.&nbsp; Is it that Joins of multiple tables cannot be accomplished and the tables must be built separately and joined after they are built to achieve the necessary results?</P></BODY></HTML> Wed, 15 Oct 2014 19:36:43 GMT https://community.qlik.com/t5/QlikView/Direct-Discovery-INVOICE-DATA/m-p/735747#M263269 bjsellers57 2014-10-15T19:36:43Z