where to put concatenate statement in script

Fri, 20 Sep 2013 10:25:55 GMT

Hi there,

I have an error with my Concatenate Statement.

Below is my script:

[AGREEMENTS]:

LOAD
AgreementNumber     as [Agreement Number],
    StatusCode      as Status,
    RegistrationNumber    as Suffix,
    CustomerReference    as [Customer Acc],
    CustomerName,
    CurrentWDV      as NBV,
    Model,
    LeaseDefinition     as [Product Type],
    LeaseDefinitNName    as [Product Description],
    Date(StartDate)     as [Start Date],
    ContractDistance,
    PeriodOfLease     as [Contract Period],
    EscalateMaintRateP    as [Escalation %],
    CompanyKey
    where StatusCode = 'L' and (LeaseDefinition='B' or LeaseDefinition='C' or LeaseDefinition='Y' or LeaseDefinition='Z');
SQL SELECT
AgreementNumber,
    StatusCode,
    RegistrationNumber,
    CustomerReference,
    CustomerName,
    CurrentWDV,
    Model,
    LeaseDefinition,
    LeaseDefinitNName,
    StartDate,
    ContractDistance,
    PeriodOfLease,
    EscalateMaintRateP,
    CompanyKey
FROM "EIE_DW".dbo."FK_agree";

LEFT JOIN (AGREEMENTS)
//[POSTING VALUES]:
LOAD
AgreementNumber     as [Agreement Number],
    Period,
    Date(DueDate)     as [Instalment Date],
    Month(DueDate)     as [Month],
    Year(DueDate)     as [Year],
    RegularRentalSpli001,
    RegularRentalSpli002   as [Rental Maintenance],
    RegularRentalSpli003,
    RegularRentalSpli004,
    Budgets001      as [Maintenance Budget],
    Interest,
    Depreciation,
    CompanyKey;
SQL SELECT
AgreementNumber,
    Period,
    DueDate,
    RegularRentalSpli001,
    RegularRentalSpli002,
    RegularRentalSpli003,
    RegularRentalSpli004,
    Budgets001,
    Interest,
    Depreciation,
    CompanyKey
FROM "EIE_DW".dbo."Fk_postv";

AGREEMENTS2:
LOAD *,
[Maintenance Budget]/(ContractDistance/[Contract Period]) as [Maintenance rate ph]
Resident AGREEMENTS;
Drop Table AGREEMENTS;
Rename Table AGREEMENTS2 TO AGREEMENTS;

[FK TRANSACTION LOG]:
LOAD
AgreementNumber    as [Agreement Number],
    InvoiceOrCredit,
    InvoiceCategory,
    DRCC,
    DRExp,
    CRCC,
    CRExp,
    NLJournalType,
    TotalValue     as [Total Value],
    CompanyKey
    where InvoiceCategory = 'MISCINV';
SQL SELECT
AgreementNumber,
    InvoiceOrCredit,
    InvoiceCategory,
    DRCC,
    DRExp,
    CRCC,
    CRExp,
    NLJournalType,
    TotalValue,
    CompanyKey
FROM "EIE_DW".dbo."FK_trans";

Concatenate (AGREEMENTS) LOAD * Resident[FK TRANSACTION LOG];

Re: where to put concatenate statement in script

Fri, 20 Sep 2013 10:35:06 GMT

The good news is it's a really easy fix;

You simply need a space between Resident and [FK TRANSACTION LOG];

Therefore, this should work;

Concatenate (AGREEMENTS) LOAD * Resident [FK TRANSACTION LOG];

Let me know how you get on.

Steve

topic where to put concatenate statement in script in Water Cooler

where to put concatenate statement in script

Re: where to put concatenate statement in script