Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ;
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
Load *;
SELECT schema.functionname(parameter)
- > 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