Needs the help for Removing the bugs in resident Loads

[kakaderanjit53]

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.

[kuczynska]

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!

[kakaderanjit53]

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.

[kuczynska]

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?

[kakaderanjit53]

ohk.