Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
data1:
NoConcatenate
LOAD Cust,
Telephone,
Line1
FROM
C:\test.qvd
(qvd);
Join (data1)
LOAD Line1 as Telephone
FROM
C:\test.qvd
(qvd);
Output:
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
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);
Hi,
you are missing joining key. else it will do Cartesian join
Regards,
I agree with you, the question asked thou is just to join two fields, a 3rd will be required to make the joining key.
If they are in the same table just do
Telephone & ',' & Line1 as CombinedField