Code: Select all
- <LineItems>
<PONumber>643730</PONumber>
- <MilestoneMessage>
- <ReferenceInfo>
<ReferenceId reference="3080951960" type="BLNumber" />
</ReferenceInfo>
- <MilestoneInfo>
<MilestoneTypeCode>105</MilestoneTypeCode>
<MilestoneTypeName>PO Accepted</MilestoneTypeName>
- <City>
<CityName>Jiangsiu</CityName>
</City>
</MilestoneInfo>
- <MilestoneInfo>
<MilestoneTypeCode>11144</MilestoneTypeCode>
<MilestoneTypeName>Supplier Booking Accepted</MilestoneTypeName>
- <City>
<CityName>Shanghai</CityName>
</City>
</MilestoneInfo>
</MilestoneMessage>
</LineItems>
LineItems\MilestoneMessage\MilestoneInfo\City
Output after join
PONUmber,BLNumber,MilestoneTypeCode,MilestoneTypeName,CityName
643730,3080951960,105,PO Accepted,Jiangsiu
643730,3080951960,11144,Supplier Booking Accepted,Shanghai