Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concatenate 2 fields

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

1 Reply
Not applicable
Author

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