topic Re: Reading data from SQL table-valued function? in QlikView

Reading data from SQL table-valued function?

Tue, 30 Dec 2014 20:35:24 GMT

Hello Experts,

How can we create a view or load table into Qlikview from SQL table-valued function

and then use this new table(view) in Qlikview.

Please suggest.

Thanks in advance.

fkeuroglian — Tue, 30 Dec 2014 23:55:16 GMT

Hi,

load the data using SQL SELECT (extract data from sql database) and the use RESIDENT to load as a view in qlikview

load *;

SQL SELECT * from Table ;

Wed, 31 Dec 2014 03:00:01 GMT

Hi,

Edit Script > Connection Required (OLEDB/ODBC) -- Connect to Server with database

Select > Table > Enable Preceding Load icon

Table Name:

> LOAD ....;

SQL SELECT *

FROM ....;

Load <>

Resident <Table Name> -- Apply any transformations

wish you happy new year

Regards,

Sub2u

SunilChauhan — Wed, 31 Dec 2014 03:18:12 GMT

Load *;

SELECT schema.functionname(parameter)

vikasmahajan — Wed, 31 Dec 2014 11:30:35 GMT

- > You can create views or temp tables in SQL using sql scripts and same can be scheduled

- > Now Create ODBC

- > Select OBDC as per attached pic.

-> Load table

vikas