I have one table, woth to fields that i want to join

[#1]

Hi,

I have two fields in the same table that contain phone numbers, one field is named Telephone and the other is named Line1, can I combine these two fields and create one field with all the numbers?

any ideas?

[goro2010]

data1:

NoConcatenate

LOAD Cust,

     Telephone,

     Line1

FROM

C:\test.qvd

(qvd);

Join (data1)

LOAD Line1 as Telephone

FROM

C:\test.qvd

(qvd);

Output:

[PrashantSangle]

Hi,

Yes you can

try like

LOAD Telephone&'-'&Line1 as phone from table

or

LOAD if(isnull(Telephone),Line1,Telephone) as phone from table

To get accureate ans please explain your requirement with sample data.

Regards,

Prashant

[qlikview979]

If 2 tables field name  are same go for concatenate  like

T1:

load

Telephone  

named Line1 

from ------xlsx);

concatenate  (T1)

T2:

load

named Line1  

Telephone

from ------xlsx);

[PrashantSangle]

Hi,

you are missing joining key. else it will do Cartesian join

Regards,

[goro2010]

I agree with you, the question asked thou is just to join two fields, a 3rd will be required to make the joining key.

[Anonymous]

If they are in the same table just do

Telephone & ',' & Line1 as CombinedField