Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
Im going to create a resident load by using 2 temporary tables which i have been created using Sql DB and QVD respectively
i.e. InputTable1 and InputTable2., But there is error occuring at the time of Resident DataLoading, please give me correct guidelines for the same.
Hi,
Can you provide some more details on your script & error message?
At the moment it's not possible to say what could be the issue here, thanks!
Set vPlant ='PLFMWISE_BRKG_TURNOVR_2016-2017';
Set vQVD ='D:\QVDs\ODS\Transactions';
InputTable:
LOAD *
From D:\QVDs\ODS\Transactions\PLFMWISE_BRKG_TURNOVR_2015-2016.qvd;
InputTable1:
LOAD *
from D:\QVDs\ODS\Transactions\PLFMWISE_BRKG_TURNOVR_2016-2017.qvd;
// Created Temporary tables for resident load
Now require the Script for resident load:
Table:
LOAD Date_Key,Fiscal_MonthName,brokerage
FROM InputTable;
;
JOIN Table
LOAD Date_
FROM InputTable1
;
Inner JOIN Table
LOAD $(myFunction(Name1,Name2))
RESIDENT Table
;
DROP FIELDS Name1, Name2
;
// join with the date_key() dimension.
Are columns in InputTable and InpuTable1 the same? If so - QV will concatenate two tables, and your result table will be called InputTable (InputTable1 will be one of the components). In that case your resident load doesn't find a source called InputTable1.
On what stage are you getting your error?
ohk.