Create Datamart using talend

Anonymous — Thu, 06 Sep 2018 06:17:34 GMT

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

Re: Create Datamart using talend

manodwhb — Thu, 06 Sep 2018 06:46:39 GMT

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

Re: Create Datamart using talend

Anonymous — Thu, 06 Sep 2018 11:05:28 GMT

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

topic Re: Create Datamart using talend in Talend Studio

Create Datamart using talend

Re: Create Datamart using talend

Re: Create Datamart using talend