Refresh Hangs up

Mon, 13 Oct 2014 21:28:54 GMT

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

topic Refresh Hangs up in QlikView

Refresh Hangs up