I have read some articles on the tdenormalize component, but I don't think it does what I want.
Example input file:
ID Name Address Email
1 Tony 49 Hill Rd Tony@somewhere.com
1 Tony 49 Hill Rd Tony@elsewhere.com
1 Tony 49 Hill Rd Tony@nowhere.com
I want to convert this to:
ID Name Address Email1 Email2 Email3
1 Tony 49 Hill Rd Tony@somewhere.com Tony@elsewhere.com Tony@nowhere.com
There will be a max of three emails, but not all may be present so I need blanks in subsequent fields.
I can see that tdenormalize can put all three emails into a SINGLE column. I don't want this.
You can do it like this ! You must aggregate with group by on id/name/adress.
And use a list object for mail.
Then in your tMap you just get the element of your list.