Talend community forum / [resolved] how to get one row as output from many rows as input with talend

nabil · 2010-12-16 16:53:10

Hi all

my source like this:

id label value
1 name alex
2 adress lot laola
3 age 22

i wanna get just one row as output like this:

id name adress age
1 alex lot lalola 22

how can I do it ??? i need help please

alevy · 2010-12-17 04:22:01

Are those the only three labels that can exist or can the labels be varied? Presumably there is also a key by which the label values can be grouped for each person?

nabil · 2010-12-22 11:28:24

only three labels that can exist , and for my input contains just one person ,my reply is late because i think i have to get a message in my box tell me that there is an answer

shong · 2010-12-23 03:14:37

Hi

and for my input contains just one person ,

If there is only person in a file, you can set the id value with a fixed value on tMap, here is an exmaple job:
in.csv:

id;label;value
1;name;alex
2;adress;lot laola
3;age;22

Best regards
Shong

Uploaded Images

nabil · 2010-12-23 11:21:26

thanks a lot Mr Shong ,i forgot to add that my output is not a file but a table in my database so how can i use your answer to get a table wich has as colums:id name adress age

shong · 2010-12-23 15:29:00

Hi
Using a tFileInputDelimited to read the result from the file and then insert the records into table.

Best regards
Shong

nabil · 2010-12-23 15:37:53

thank you very much

Announcement

Unanswered posts

#1 2010-12-16 16:53:10

[resolved] how to get one row as output from many rows as input with talend

#2 2010-12-17 04:22:01

Re: [resolved] how to get one row as output from many rows as input with talend

#3 2010-12-22 11:28:24

Re: [resolved] how to get one row as output from many rows as input with talend

#4 2010-12-23 03:14:37

Re: [resolved] how to get one row as output from many rows as input with talend

#5 2010-12-23 11:21:26

Re: [resolved] how to get one row as output from many rows as input with talend

#6 2010-12-23 15:29:00

Re: [resolved] how to get one row as output from many rows as input with talend

#7 2010-12-23 15:37:53

Re: [resolved] how to get one row as output from many rows as input with talend

Board footer