topic Re: Data from SQl schema in QlikView

Data from SQl schema

Wed, 11 Sep 2013 11:06:46 GMT

Hi,

Can any one help to read data from SQL schema in qlikview?

Thanks in advance.

Re: Data from SQl schema

Wed, 11 Sep 2013 11:10:50 GMT

Do you mean reading data from SQL and pulling it into Qlikview?

Re: Data from SQl schema

Wed, 11 Sep 2013 11:14:17 GMT

Yes. Reading data or table information from SQL schema or database diagram.

Re: Data from SQl schema

Wed, 11 Sep 2013 11:14:29 GMT

Hi,

Same question for me. And also is there ant way to pull data from SQL View instaed of Table. If so, Could you please let me know how to do this.

Thanks,

Amelia.

Re: Data from SQl schema

Wed, 11 Sep 2013 11:20:14 GMT

You can use Load statement in qlikview after using the normal sql query to pull data from database and make it available in qlikview.

For Example:

Test: (Qlikview Tablename)

Select Order_no,

Order_Name,

City,

State,

Zip

from Tablename; (This is Database Tablename)

Load *

from Tablename;

Here Test is your qlikview Table name. You will be pulling the data from sql using "select" Query.

Then using "Load" query you are making the data available in qlikview. Here you can use many transformations to manipulate the data.

Hope this helps!

If this is not what you were looking for, please post a sample.

Re: Data from SQl schema

israrkhan — Wed, 11 Sep 2013 12:26:16 GMT

yes, its same like table,

when you go to select tables and fields, here you will see view check box, if you check it, you will see all views, that you have in your database, and you can select view and then fields what you want, try and let me know, if you need an example..

Re: Data from SQl schema

Wed, 11 Sep 2013 13:36:28 GMT

Thanks for your answer and it's working

Amelia.