Join two load table fields into one new field.

[bnelson111]

This is one i have been struggling with, is it possible from the loaded tables below to make a new field to link to.

i would like to have the CustItemRef from [So info]: and ShipReqNum from [Shipping info]:

into text([CustItemRef]&[ShipReqNum]) as 1,

is this possible??

[Shipping info]:

LOAD

ShipReqNum,

    ShipQty,

    Consignment,

    CustRef,

    SOrderNum;

SQL SELECT

    ShipReqNum,

    ShipQty,

    Consignment,

    CustRef,

    SOrderNum

FROM PUB."PV_ShipReqLine";

left join

[So info]:

LOAD FCUnitPrice,

ReqDate,

    UnitPrice,

CustItemRef,

SOrderNum,

ItemCode;

SQL SELECT FCUnitPrice,

CustItemRef,

ReqDate,

    UnitPrice,

    SOrderNum,

ItemCode

FROM PUB."PV_SOrderLine";

[Peter_Cammaert]

The simplest way to do this is to

NewShippingInfo:

NOCONCATENATE

LOAD *, [CustItemRef] & [ShipReqNum] AS NewField

RESIDENT ShippingInfo;

DROP Table ShippingInfo;

RENAME TABLE NewShippingInfo INTO ShippingInfo;

after the JOIN or something.

Peter

[maxgro · Accepted solution]

hope I understand your question

add at the end of your script

NewShippingInfo:

noconcatenate

load

     *,

     [CustItemRef]&[ShipReqNum] as NewField

resident [Shipping info];

drop table [Shipping info];

rename table NewShippingInfo to [Shipping info];

[bnelson111]

Thanks, Brilliant

[bnelson111]

Thanks, Brilliant