Create Datamart using talend

[Anonymous]

hi,

i have a data source like this :

User	Day	Value	Category
Dennis	1	50	A
Dennis	1	50	A
Dennis	2	100	A
Dennis	3	100	B
Lyna	1	50	A
Lyna	2	100	A
Lyna	2	50	B
Lyna	3	100	B

then i want the result to be like this

USER	Day_1	Day_2	Day_3	Category_A	Category_B	All_day
Dennis	100	100	100	200	100	300
Lyna	50	150	100	150	150	300

I do that using a manual query before, when the data is in rdbms(oracle), now the data source already in the hive, I need advice and input, if I want to do that using talend, what components do I need? and how are the steps

Thx  

[manodwhb]

@Jackson66,in tMap you can do by using variable ports.

[Anonymous]

thanks for advice, and now, how can i transpose by day in talend