Flatten keyword in Pig

[Simha G]

Hi Team,

I have a source data like below,

{(03-07-2011),(03-07-2011)},{(Jackson),(Jackson)},{(Mississippi),(Mississippi)},{(Team
Sports),(Team Sports)},{(credit),(credit)}
{(11-14-2011),(11-14-2011)},{(Des Moines),(Des
Moines)},{(Iowa),(Iowa)},{(Outdoor Play Equipment),(Outdoor Play
Equipment)},{(credit),(credit)}

 And i want the data in tupples, I tried like below

 mydata = load '/user/flatendata' USING PigStorage(',') as (id:chararray,
name:chararray, lastname:chararray, hobby:chararray, city:chararray);

 flatted = foreach mydata genereate flatten(id), flatten(name),
flatten(lastname), flatten(hobby);

but i am getting below output ,

({(03-07-2011),(03-07-2011)},{(Jackson),(Jackson)})
({(11-14-2011),(11-14-2011)},{(Des Moines),(Des Moines)})


Could you please suggest me how to get the below flatten data.

 (03-07-2011,03-07-2011,Jackson,Jackson,Mississippi,Mississippi,Team
Sports,Team Sports,credit,credit)
(11-14-2011,11-14-2011,Des Moines,Des Moines,Iowa,Iowa,Outdoor Play
Equipment,Outdoor Play Equipment,credit,credit)


Thanks,
Narasimha