Powershell script to parse xml in csv and expand it
$records = Import-Csv BadResults.csv
foreach($record in $records){
$xml = new-object System.Xml.XmlDocument
$fraudScore = $record.FraudScoreDetails
$xml.LoadXml($fraudScore)
foreach ($i in $xml.response.rule){
#Write-Output $i.criteriaEvaluated
#Write-Output $i.evaluationResult
$record | Add-Member NoteProperty $i.criteriaEvaluated $i.evaluationResult
}
}
$records | Export-Csv -Path ExpandedBadResults.csv -NoTypeInformation