How to concatenate direct query table with in memory table

[israq]

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,

[Marcos_rv]

could you give us an example? please

[israq]

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]

Any ideas? I need exactly the same. 🙂 

[marcus_sommer]

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

- Marcus