Concatenate two fields

[Anonymous]

Good day,

I have a Customer field and a CustomerID field that I need to combine as one.

I believe the text should be:

  CustomerID&" "&Customer name as Customer_Name

Is this correct and where and how should I define this to create the new combined field?

Please help!

[#2]

this almost correct. correct in the case would be   CustomerID&' '&Customer name as Customer_Name

you implement in you script

example:

load

CustomerID&' '&Customer name as Customer_Name,

CustomerID,

[Customer name]

from source...

[vinieme12]

if you don't want to add a separator to distinguish then this is fine

Remember fieldname with spaces need to placed in square brackets

CustomerID&[Customer name] as Customer_Name

or

CustomerID&'-'&[Customer name] as Customer_Name (use a hyphen or _  underscore)

Cheers

V

[Anonymous]

I have first created an inline table and then on top of that using preceding load ! created [Customer Name]. If you are exporting value from some external data file, in the same stage you can write the code [Customer ID] & ' ' & Customer as [Customer Name] and create the new field.

I have created a qvw for you in the attachment.

LOAD *,

[Customer ID] & ' ' & Customer as [Customer Name];

LOAD * INLINE [

    Customer ID, Customer

    1, AB

    2, BC

    3, CD

    4, DE

    5, EF

];

[Anonymous]

Hi,

Thank you for your quick response. I don't see the attachment though (or am I just being stupid?).

Regards

[Anonymous]

I have attached again

[avinashelite]

I suggest to with

CustomerID&'-'&[Customer name] as Customer_Name

having space in the Key doesn't sounds good.

[Chanty4u]

try this

  CustomerID&"_"&[Customer name] as Customer_Name

[engishfaque]

Dear Martin,

Field Concatenation:

Use single quote instead of double quote and use brackets when you have a field name with space such as given below,

CustomerID & ' ' & [Customer name] as Customer_Name

Kind regards,

Ishfaque Ahmed