Concatenate 2 fields

Thu, 23 Aug 2012 08:03:30 GMT

Hello,

simple question i hope, but i cant remember it now, even if it is possible:

I Have 2 tables with Fields:

1. CUSTACCOUNT, Address, Zipcode

2. Custaccount, SAPCITY

I need to merge the following Fields into one:

Address, Zipcode, SAPCITY

The result should be table 3.:

CUSTOACCOUNT, ADDRESS(complete)

Thank you in advance for your help.

Greetings,

Kristian

Re: Concatenate 2 fields

Thu, 23 Aug 2012 08:05:37 GMT

Map_2:

MAPPING LOAD

Custaccount AS CUSTACCOUNT,

SAPCITY;

SQL SELECT YADAYADA;

Final_Table:

Load CUSTACCOUNT,

Address & ', ' & Zipcode & ', ' & ApplyMap('Map_2',CUSTACCOUNT,'') AS Address_Complete;

SQL SELECT YADAYADA