-1

I have the dataset like this dataset

and want out put like this how can I do thatoutputenter image description here Here is sample dataset 

ID  COMP_ID CAR_ID  ENGINE  COLOR   CC
1   c1  car3    xyz blue    2500
2   c2  car4    xyz white   1000
3   c1  car6    xyz green   3500
4   c2  car1    xyz black   4500
5   c3  car5    xyz green   4000
6   c1  car2    xyz red 3000
7   c2  car3    xyz gray    1500
8   c3  car4    xyz silver  2000
Ahmad Qasim
  • 452
  • 1
  • 8
  • 26
  • 2
    What have you tried so far? One possible way would be using tAggreateRow and/ or tDenormalize. – tobi6 Oct 23 '17 at 13:11
  • I did nothing just thinking how can i did this – Ahmad Qasim Oct 24 '17 at 06:12
  • 1
    Stack Overflow is no code production service. This question is very broad and involves many steps. It would be a good start to see at least a job layout you thought about. The community is happy to help for specific questions. – tobi6 Oct 24 '17 at 08:04
  • sir actually i am using talend and try tmap, taggregate and like these components. after getting below answer i used tjavarow and tdenormlized but not successful yet – Ahmad Qasim Oct 24 '17 at 10:20

1 Answers1

2

You can try a tJavaRow something like : 

output_row.foo=input_row.row1+"\n"+input_row.row2;

foo must exist in your Output Schema and row1 and row2 in your Input Schema

Else, you can concatenate them in a TMap in the same way.

Esteban Chamard
  • 100
  • 1
  • 2
  • 12