Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
israq
Contributor II
Contributor II

How to concatenate direct query table with in memory table

Hi Guys,

Please share with me on how to concatenate direct query table with in memory table. I have a ready in memory table that need to incorporate with direct query table sharing same calendar. Both table having same keys.

Thanks,
4 Replies
Marcos_rv
Creator II
Creator II

could you give us an example? please

israq
Contributor II
Contributor II
Author

Hi Marcos,

Thanks for your reply.

Basically I'm trying to concatenate qvd with direct query table. I have no issue to concatenate 2 qvd.

You may refer below sample script. Error prompted 'No Direct Statement'

Budget:
LOAD 
STOREDATE_KEY
DATE,
Bg_DailyBudget_S,
Bg_DailyForecast_S
FROM
[E:\Qlikview\Production\QVDs\Others\BUDGETMASTERDATA_S.qvd]
(
qvd);
 
ODBC CONNECT TO DIRECTQUERY (XUserId is 2134, XPassword is fdgfgh);
 
 SalesDQ:
Concatenate (Budget)
DIRECT QUERY
DIMENSION
STOREDATE_KEY,
DATE
MEASURE
NETSALES
FROM [dbo].[DIRECT_QUERY]
 

 

 

denisb
Contributor III
Contributor III

Any ideas? I need exactly the same. 🙂 

marcus_sommer
MVP & Luminary
MVP & Luminary

Never used this feature but I doubt that's possible. Don't try to concatenate these tables else associate them.

- Marcus