topic Re: Re: Method to Join Three Fields Values into One in QlikView

Method to Join Three Fields Values into One

Fri, 21 Mar 2014 08:58:09 GMT

Hi, I want to join three fields values into one field. Please check the sample

Re: Method to Join Three Fields Values into One

its_anandrjs — Fri, 21 Mar 2014 09:02:46 GMT

Hi,

For which three field you are asking about it is this

Branch1 Sale

Branch2 Sale

Branch 3 Sale

Thanks & Regards

Re: Method to Join Three Fields Values into One

Fri, 21 Mar 2014 09:05:15 GMT

Branches(Branch1, Branch2, Branch3) Description(Branch1, Branch2, Branch3) Sale(Branch1, Branch2, Branch3) 1 Wind 2,800,000.00 2 Air 1,000,000.00 3 xxx 0.00 4 xxx 0.00 5 Renewable 2,750,000.00 6 xxx 0.00 7 xxx 0.00 8 xxx 0.00 9 xxx 0.00 10 Textile 2,000,000.00 99 Others 450,000.00 Total Sale 9,000,000.00

Re: Method to Join Three Fields Values into One

Fri, 21 Mar 2014 09:05:29 GMT

I need in this manner

Re: Method to Join Three Fields Values into One

Fri, 21 Mar 2014 09:06:14 GMT

in a way Yes, want to club these three fields sale but branches wise.

Re: Method to Join Three Fields Values into One

its_anandrjs — Fri, 21 Mar 2014 09:28:57 GMT

Hi,

Ok load your tables in three parts and concatenate this tables and do aggregation in another table and load this table like

LOAD Customer,

Branch1 as Branches,

[Branch1 Desc] AS Description,

//[Branch1 %],

[Branch1 Sale] AS Sale

FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate

Load

Customer,

Branch2 AS Branches,

[Branch2 Desc] AS Description,

//[Branch2 %],

[Branch2 Sale] AS Sale

From

(ooxml, embedded labels, table is Sheet1);

Concatenate

load

Customer,

Branch3 as Branches,

[Branch3 Desc] AS Description,

//Branch3%,

[Branch 3 Sale] AS Sale

//[Sale Year 2014]

FROM

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

Temp:

load

RecNo() as Rowid

Resident A;

Left Join

LOAD

sum(Sale) as Sale

Resident Temp

Group by Description;

DROP Table A;

Hope this helps

Thanks & Regards

Re: Method to Join Three Fields Values into One

Fri, 21 Mar 2014 09:33:56 GMT

Or already use the concatenate function in excel (CONCATENATE( text1, text2, ... text_n )) and add it as a new field to your source (probably easier).You won't have to edit your script much in this case..

Re: Re: Method to Join Three Fields Values into One

Fri, 21 Mar 2014 09:36:16 GMT

please find my data structure,

if I do this thing, nothing works.

and if I don't concatenate and form three tables, it forms a circular loop.

Re: Re: Method to Join Three Fields Values into One

Fri, 21 Mar 2014 09:38:17 GMT

sorry but I didn't got your answer

Re: Method to Join Three Fields Values into One

Fri, 21 Mar 2014 09:41:42 GMT

FYR