Reading data from SQL table-valued function?

[#1]

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]

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 ;

Diff between SQL Select and Load Statement

[#3]

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]

Load *;

SELECT schema.functionname(parameter)

[vikasmahajan]

- >  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