Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys
I am working on an interval match script.
Here my refresh hangs at the point where I have bolded my script.
Please advise
MSCExRates:
LOAD
*
FROM MSCExRates.qvd(qvd);
MSCRegionalCurr:
LOAD
*
FROM MSCRegionalCurr.qvd(qvd);
BaseExRates:
load [MSC Ex Rate] as [Rptg Avg Rate],
[MSC Ex Start Date] as [Rptg Avg Rate Start Date],
[MSC Ex End Date] as [Rptg Avg Rate End Date] ,
[MSC Ex From Currency] as [Schd Base Curr Cd],
'USD' as [Schd Rptg Curr Code]
resident MSCExRates where [MSC Ex Rate Type] = 'Period Average';
RegionalExRates:
load [MSC Ex Rate] as [Regional Avg Rate],
[MSC Ex Start Date] as [Regional Avg Rate Start Date],
[MSC Ex End Date] as [Regional Avg Rate End Date] ,
[MSC Ex From Currency] as [Schd Base Curr Cd],
[MSC Ex To Currency] as [Regional Curr Cd] resident MSCExRates where [MSC Ex Rate Type] = 'Period Average';
RegionalCurr:
mapping load [Regional Curr SOB ID], [Regional Currency Code] as [Regional Curr Cd] resident MSCRegionalCurr;
SchedulesTmp:
LOAD * FROM Schedules.qvd(qvd);
Drop field [Schedules Incremental ID];
Drop Field [Schedules Incremental Date];
Schedules:
LOAD *,ApplyMap('RegionalCurr',[Schd SOB ID]) as [Regional Curr Cd] RESIDENT SchedulesTmp;
Drop table SchedulesTmp;
Drop table MSCRegionalCurr;
Drop table MSCExRates;
//Functional to Reporting
left join(Schedules)
IntervalMatch([GL Date],[Schd Base Curr Cd],[Schd Rptg Curr Code])
Load
[Rptg Avg Rate Start Date],
[Rptg Avg Rate End Date],
[Schd Base Curr Cd],
[Schd Rptg Curr Code]
Resident BaseExRates;
left join(Schedules)
Load *
Resident BaseExRates
;
The reload fails at the second reload of the table BaseExRates. Please advise what I am doing wrong
Thanks
Drop table BaseExRates;
// Base to regional Conversion
Left join (Schedules)
IntervalMatch ([GL Date],[Schd Base Curr Cd],[Regional Curr Cd])
load
[Regional Avg Rate Start Date],
[Regional Avg Rate End Date],
[Schd Base Curr Cd],
[Regional Curr Cd]
resident RegionalExRates;
Left join (Schedules)
Load * resident RegionalExRates;
Drop table RegionalExRates;
drop field [Base Avg Rate Start Date];
drop field [Base Avg Rate End Date];
drop field [Regional Avg Rate Start Date];
drop field [Regional Avg Rate End Date];
The reload fails at the second reload of the table BaseExRates. Please advise what I am doing wrong