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.
For me this sounds, There is Privileges problem to the schema?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Add each measure separately to the Master Item and call it out to needed color.
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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 ##?
