Hi all,
We are converting CSV files(Input) to XML files(Output).
Input file format:
Empno, Ename, Job
1,X,A
2,Y,B
3,Z,C
Required Output file:
<ApplicationPrincipalAttributeValues>
<AppAttributeName>Empno</AppAttributeName>
<AppAttributeValue>1</AppAttributeValue>
</ApplicationPrincipalAttributeValues>
<ApplicationPrincipalAttributeValues>
<AppAttributeName>Ename</AppAttributeName>
<AppAttributeValue>X</AppAttributeValue>
</ApplicationPrincipalAttributeValues>
<ApplicationPrincipalAttributeValues>
<AppAttributeName>Job</AppAttributeName>
<AppAttributeValue>A</AppAttributeValue>
</ApplicationPrincipalAttributeValues>
To do this process, do we need to convert above input file to the following format shown below before converting to XML format..; or is there any other option which can convert directly to above XML output.
Empno, 1
Ename ,X
Job, A
Empno ,2
Ename, Y
Job, B
Empno ,3
Ename, Z
Job , C
Thanks,
CSV to XML Issues
Moderators: chulett, rschirm, roy
Re: CSV to XML Issues
Hi Diya,
You cannot have output like this.For that you need another root tag above your <ApplicationPrincipalAttributeValues> and use aggregate mode in setting . Then you can get this result.
You cannot have output like this.For that you need another root tag above your <ApplicationPrincipalAttributeValues> and use aggregate mode in setting . Then you can get this result.