Method to Join Three Fields Values into One

[#1]

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

[its_anandrjs]

Hi,

For which three field you are asking about it is this

Branch1 Sale

Branch2 Sale

Branch 3 Sale

Thanks & Regards

[#3]

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

[#4]

I need in this manner

[#5]

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

[its_anandrjs]

Hi,

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

A:

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

[#7]

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

[#8]

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.

[#9]

sorry but I didn't got your answer

[#10]

FYR