Concatenation Problem

[#1]

Hello , I have 2  table :

HSBC table ,

Name	Hsbc Identifier	Units
ANJUERRE SOPHIE	11100_FRA0000990158	1222
ANJUERRE SOPHIE	11100_FRA0000980114	280

Pivot Table

NAME	Hsbc Identifier 1	Hsbc Identifier 2
ANJUERRE SOPHIE	11100_FRA0000990158	11100_FRA0000980114

I want to visualise This

NAME	Hsbc Identifier 1	Hsbc Identifier 2	Sum(Units)
ANJUERRE SOPHIE	11100_FRA0000990158	11100_FRA0000980114	1502

Some One can help me please , i debute in QV

please See attached

[christophebrault]

Hi,

// You can do something like this :

Load your first table :

TABLE:

LOAD Name,

          Hsbc_identifier,

          ...,

          Units

FROM ... ;

If you Want to sum the units and have only one line per Name value, you'll have to "group by" :

NoConcatenate

RESULT:

LOAD Name,

          Sum(Units) as Units

Resident TABLE Group By Name;

drop table TABLE;

// Left join additionnals infos from another file :

Left Join

LOAD Name, // Will left join on this field

          Hsbc_Identifier_1,

          Hsbc_Identifier_2

FROM ... ,

[#3]

Hey Christophe ,

I dont intersteand very well yourt solution

[#4]

Can U give me a example please

I attached , a Qv and xls file

[#5]

Please check the attachment is it serves your purpose.

[#6]

Hey Sudoh

Your script doesnt work when  i add a rows to my pivot table

[#7]

Does it give any error?

Can you check the path of your files? - I worked out the script based on my local path - however, I changed the path to yours while reposting.

Alternatively, can you share a slightly bigger data - maybe 4 or 5 rows?

[#8]

    Hi Subodh ,

I employeed your solution with a other project , but its doesnt work , do you have a subjection ? Please see the attachement thank u a lot

[SunilChauhan]

see for ur sample data u can implement below

tab1:

Load * inline [

Name, HsbcIdentifier, Units

ANJUERRE SOPHIE, 11100_FRA0000990158 ,1222

ANJUERRE SOPHIE, 11100_FRA0000980114, 280

];

[Pivot Table]:

Load * inline [

NAME ,Hsbc Identifier 1 ,Hsbc Identifier 2

ANJUERRE SOPHIE, 11100_FRA0000990158, 11100_FRA0000980114

];

left Join

Load Name,

Sum(Units) as Units

resident tab1 group by Name;

drop table tab1;

u can apply same logic on xls data.

see the attached file

hope this helps

[#10]

     Hi Sunil ,

i want something like this  , For each CCN , show the    quantite of parts