XML Output format help
Posted: Thu Jun 24, 2010 11:16 am
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?
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?