Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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