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
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.