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

How to concatenate direct query table with in memory table

israq — Tue, 29 Jan 2019 22:02:59 GMT

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,

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

Marcos_rv — Mon, 04 Feb 2019 16:32:39 GMT

could you give us an example? please

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

israq — Tue, 05 Feb 2019 01:34:03 GMT

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]

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

denisb — Wed, 28 Oct 2020 14:38:40 GMT

Any ideas? I need exactly the same. 🙂

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

marcus_sommer — Thu, 29 Oct 2020 12:43:14 GMT

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

- Marcus