I need to generate an XML file of the following structure:
I could have only 1 name and designation and multiple addresses in one employee recordset.
I am using FCC ( File content conversion)
Here are the parameters:
Recordset Structure: Name,1,Address,*,Designation,1
Key Field Name: key
Key Field Type: Integer
My input is:
Sam,Smith,1,100 Golden Drive,San Diego,77990,1,121 silver beach,san diego,77905,Manager
Dave,Green,1,111 abey lane,orange,77665,HR
Can you tell me what more I need to specify to get this working?