CUST_ADDR2 & ' ' & CUST_CITY & '' &CUST_STATE & '' &CUST_ZIP & '' &CUST_COUNTRY as [Supplier Location]
After Concatenate my data for supplier location is like this .Please find Screen shot
My requirement is i need to see data in this format..PFA screen shot
Can you upload your sample data and manipulate your desire result? So that it easy for other to test with QlikView.
just use a straight table and seet the settings in custom setting
Retrieving data ...