Merging fields

[#1]

Hi All,

I have one table, which contains fields A, B, C, D, E.

My requirement is i want to merge 3 fields as one field

like A,B, C as A1,

B,C,D as B1

And for these A1, B1 Again i have to create one field as follows

A1
A
B
C

B1
B
C
D

TOTAL
A1
B1

is there any possibility in Qlikview?

Please help me on this

Thanks,

Vamsi.

[tresesco]

Though not very clear, you can try:

Load

          A1,

          B,

          A1&B1 as TOTAL

;

Load

          A&B&C as A1

          B&C&D as B1

From <>;

note: '&' is string concatenation operator, if you want to add the numeric values you can similarly use '+' like:

Load A+B+C as A1 ....

[#3]

hi

can you give data sample

[sujeetsingh]

Reddy ,

It is confusing little bit.

[#5]

I have one table which contains fields COMPANY, COMPANY_2,STATE .  Requirement is I want to show COMPANY, COMPANY_2,STATE as Address filed in list box as follows

Please can anyone help on this.

Thanks,

Chiru

[#6]

Hi

use like this ,

Address:

load * inline [

city,state,country,hno

chennai,tamilnadu,india,14

hyd,AP,india,23

];

LOAD city &'    '& state &'    ' & country&'    ' & hno as addres Resident Address;

[tresesco · Accepted solution]

May be like attached sample

[#8]

HI tresesco,

This is exactly what i'm expecting is

Thanks for your support on this.

Thanks,

Vamsi