topic Re: QlikView application should point to new schema tables instead of the data files in QlikView

QlikView application should point to new schema tables instead of the data files

Anonymous — Tue, 16 Jan 2018 16:42:06 GMT

presently our qlikview application is using source data files and new requirement is to use schema table..... data is same but it should fetch from schema tables....

Re: QlikView application should point to new schema tables instead of the data files

rwunderlich — Tue, 16 Jan 2018 18:50:59 GMT

What is a "schema table"? It's not a term I'm understanding in this context.

-Rob

Re: QlikView application should point to new schema tables instead of the data files

Anonymous — Tue, 16 Jan 2018 21:20:53 GMT

A database schema is the skeleton structure that represents the logical view of the entire database.

Re: QlikView application should point to new schema tables instead of the data files

rwunderlich — Wed, 17 Jan 2018 04:06:02 GMT

You can access the catalog schema using the SQLTABLES script statement. What I didn't understand was your statement "data is same..."

-Rob

Re: QlikView application should point to new schema tables instead of the data files

Anonymous — Thu, 18 Jan 2018 16:05:09 GMT

Hi,

I want to connect Materialised views in database to an existing qlikview QVW. How should I point to Materialised views instead of Qvd.

Re: QlikView application should point to new schema tables instead of the data files

rwunderlich — Thu, 18 Jan 2018 19:18:26 GMT

SQL SELECT?