XML Output format help

[reachsam11]

Hi,

Input to XML Output stage is
---------------------------------
randy6666,000001
Henry12345,000002
Henry12345,000003
Jill7890,000004
Jill7890,000005
Jill7890,000006


XMap defined
-------------
/Request/@ID
/Request/@Version
/Request/Action/text()
/Request/Parameters/Users/UserID/@ID (ser this as primary key)
/Request/Parameters/Users/UserID/AccountInfo/AccountNum/@ID


I am expecting the output i the format as
-----------------------------------------------------
<Request ID="2010-06-21-47130101" Version="1">
<Action>SaveUserAccounts</Action>
<Parameters>
<Users>
<UserID ID="randy6666">
<AccountInfo>
<AccountNum ID="000001"></AccountNum>
</AccountInfo>
</UserID>
<UserID ID="Henry12345">
<AccountInfo>
<AccountNum ID="000002"></AccountNum>
<AccountNum ID="000003"></AccountNum>
</AccountInfo>
</UserID>
<UserID ID="Jill7890">
<AccountInfo>
<AccountNum ID="000004"></AccountNum>
<AccountNum ID="000005"></AccountNum>
<AccountNum ID="000006"></AccountNum>
</AccountInfo>
</UserID>
</Users>
</Parameters>
</Request>


But the XML output prouduced by the job is
-----------------------------------------------------
<Request ID="2010-06-21-47130101" Version="1">
<Action>SaveUserAccounts</Action>
<Parameters>
<Users>
<UserID ID="randy6666">
<AccountInfo>
<AccountNum ID="000001"></AccountNum>
</AccountInfo>
</UserID>
<UserID ID="Henry12345">
<AccountInfo>
<AccountNum ID="000002"></AccountNum>
</AccountInfo>
</UserID>
<UserID ID="Henry12345">
<AccountInfo>
<AccountNum ID="000003"></AccountNum>
</AccountInfo>
</UserID>
<UserID ID="Jill7890">
<AccountInfo>
<AccountNum ID="000004"></AccountNum>
</AccountInfo>
</UserID>
<UserID ID="Jill7890">
<AccountInfo>
<AccountNum ID="000005"></AccountNum>
</AccountInfo>
</UserID>
<UserID ID="Jill7890">
<AccountInfo>
<AccountNum ID="000006"></AccountNum>
</AccountInfo>
</UserID>
</Users>
</Parameters>
</Request>


What should i change to get the desired output XML?

[reachsam11]

Oops, found the solution. I should set 'AccountNum' as Key and not 'UserID'. It works