Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
israq
New 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,
2 Replies
Marcos_rv
Contributor II

Re: How to concatenate direct query table with in memory table

could you give us an example? please

israq
New Contributor II

Re: How to concatenate direct query table with in memory table

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]