concatenating the values of 2 different fields to one field in a table

[anushahegde]

Hi all,

Temp:

Load

ListPriceTypeID,

'43' as NetPriceTypID

From abc.qvd;

In the ablove script, I want a single field called PriceTypeID that contains the values of both ListPriceTypeID and NetPriceTypID. How can I get it ?

For example if,

the values of ListPriceTypeID are

1

2

3

4

output should be:

PriceTypeID

1

2

3

4

43

Appreciate your help.

Thanks in advance,

Anusha.

[christophebrault]

Hi,

You can concatenate by loading the data twice :

Temp:

Load

ListPriceTypeID

From abc.qvd;

Concatenate(Temp)

LOAD

Temp:

Load

'43' as ListPriceTypeID

From abc.qvd;

[balabhaskarqlik]

May be this:

Temp:

Load

ListPriceTypeID,

'43' as NetPriceTypID

From abc.qvd;

NoConcatenate

Temp1:

Load

ListPriceTypeID

Resident Temp;

Concatenate (Temp1)

Load

'43' as NetPriceTypID

Resident Temp;

Drop table Temp;

Temp2:

Load

ListPriceTypeID as PriceTypeID

Resident Temp1;

Drop table Temp1;