You are not logged in.
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?
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
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:
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
Using a tFileInputDelimited to read the result from the file and then insert the records into table.