Hi,
I would like to deep dive to xml fileds get id values of each defects. As of now I have used "Get Elements" and provided element name ="Field" and xml path in the input, So it pulled all the filed from xml and stored in to Elements collection. Now I want to iterate Elements collection get below attribute values from it and store it in excel. I have attached my xml in .txt format. Below attributes will repeat 10 times each, that means we have 10 defects in the xml. Attached my workflow, and respective screenshot for reference. Kindly help me to get the solution. It little urgent. Workflow also I have attached .txt format, kindly convert it to .xml.
Attributes to extract (below are example):
1.subject -1001
2.project -Test_Project
3.creation-time -2020-04-15
4.id -1
5.severity- 5-Urgent
6.detected-by -mc_ixmagual
7.priority -5-Urgent
8.detected-in-rcyc -SIT Cycle 2(Note : Here I need to get ReferenceValue)
9.name -Login page is not displayed
Xml tag to get values extract from:
<Field Name="subject"><Value>1001</Value></Field>
<Field Name="project"><Value>Test_Project</Value></Field>
<Field Name="creation-time"><Value>2020-04-15</Value></Field>
<Field Name="id"><Value>1</Value></Field>
<Field Name="severity"><Value>5-Urgent</Value></Field>
<Field Name="detected-by"><Value>mc_ixmagual</Value></Field>
<Field Name="priority"><Value>5-Urgent</Value></Field>
<Field Name="detected-in-rcyc"><Value ReferenceValue="SIT Cycle 2">1002</Value></Field>
<Field Name="name"><Value>Login page is not displayed</Value></Field>
I would like to deep dive to xml fileds get id values of each defects. As of now I have used "Get Elements" and provided element name ="Field" and xml path in the input, So it pulled all the filed from xml and stored in to Elements collection. Now I want to iterate Elements collection get below attribute values from it and store it in excel. I have attached my xml in .txt format. Below attributes will repeat 10 times each, that means we have 10 defects in the xml. Attached my workflow, and respective screenshot for reference. Kindly help me to get the solution. It little urgent. Workflow also I have attached .txt format, kindly convert it to .xml.
Attributes to extract (below are example):
1.subject -1001
2.project -Test_Project
3.creation-time -2020-04-15
4.id -1
5.severity- 5-Urgent
6.detected-by -mc_ixmagual
7.priority -5-Urgent
8.detected-in-rcyc -SIT Cycle 2(Note : Here I need to get ReferenceValue)
9.name -Login page is not displayed
Xml tag to get values extract from:
<Field Name="subject"><Value>1001</Value></Field>
<Field Name="project"><Value>Test_Project</Value></Field>
<Field Name="creation-time"><Value>2020-04-15</Value></Field>
<Field Name="id"><Value>1</Value></Field>
<Field Name="severity"><Value>5-Urgent</Value></Field>
<Field Name="detected-by"><Value>mc_ixmagual</Value></Field>
<Field Name="priority"><Value>5-Urgent</Value></Field>
<Field Name="detected-in-rcyc"><Value ReferenceValue="SIT Cycle 2">1002</Value></Field>
<Field Name="name"><Value>Login page is not displayed</Value></Field>