Qlik Community

Qlik Sense App Development

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

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. 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
Highlighted

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

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)
Highlighted
nihhalmca
Valued Contributor II

Re: Extract data from #temp tables SQL Server

Hi, anyone of you assist on this please?

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

Highlighted
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 ##?