topic Re: Merging fields in QlikView

Merging fields

Thu, 03 Oct 2013 08:02:30 GMT

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.

Re: Merging fields

tresB — Thu, 03 Oct 2013 08:29:07 GMT

Though not very clear, you can try:

Load

A1,

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 ....

Re: Merging fields

Thu, 03 Oct 2013 08:32:30 GMT

can you give data sample

Re: Merging fields

sujeetsingh — Thu, 03 Oct 2013 08:34:45 GMT

Reddy ,

It is confusing little bit.

Re: Merging fields

Thu, 03 Oct 2013 10:45:25 GMT

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

Re: Merging fields

Thu, 03 Oct 2013 10:57:36 GMT

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;

Re: Re: Merging fields

tresB — Thu, 03 Oct 2013 11:00:51 GMT

May be like attached sample

Re: Merging fields

Thu, 03 Oct 2013 16:15:57 GMT

HI tresesco,

This is exactly what i'm expecting is

Thanks for your support on this.

Thanks,

Vamsi