Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
nihhalmca
Valued Contributor II

Extract data from #temp tables SQL Server

Hi All,

I tried to extract data from #temp tables to Qlik Sense. However load will extract zero records where as SQL Server shows records with same query.

Do i need to add any script to query,as of now written like

SQL

Select

--

#temptable;

Actually i am assuming that #temptables stored in virtual memory (not physical) in SQL Server so Qlik is unable to load records/data. Is it correct? please share you knowledge if you were experienced it.

Thanks, Nihhal.

5 Replies

Re: Extract data from #temp tables SQL Server

For me this sounds, There is Privileges problem to the schema?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: Extract data from #temp tables SQL Server

Add each measure separately to the Master Item and call it out to needed color.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
nihhalmca
Valued Contributor II

Re: Extract data from #temp tables SQL Server

Hi, anyone of you assist on this please?

Ilya_Bobrov
New Contributor III

Re: Extract data from #temp tables SQL Server

Perhaps you can create some kind of view or materialized view? What is the need to use tmp tables?

Partner
Partner

Re: Extract data from #temp tables SQL Server

A #table has scope only within the session that creates it.

A ##table, on the other hand, is temporary but can be accessible from all sessions. It gets deleted when the last session that accessed it comes to an end. Maybe use ##?