How to concatenate direct query table with in memory table
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.
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]