topic Join two load table fields into one new field. in QlikView

Join two load table fields into one new field.

bnelson111 — Tue, 04 Feb 2014 12:55:20 GMT

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";

Re: Join two load table fields into one new field.

Peter_Cammaert — Tue, 04 Feb 2014 13:06:05 GMT

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

Re: Join two load table fields into one new field.

maxgro — Tue, 04 Feb 2014 13:10:47 GMT

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];

Re: Join two load table fields into one new field.

bnelson111 — Tue, 04 Feb 2014 13:15:18 GMT

Thanks, Brilliant

Re: Join two load table fields into one new field.

bnelson111 — Tue, 04 Feb 2014 13:15:18 GMT

Thanks, Brilliant