Looking for ideas on an approach for this.
-Directory contains ~370 xml files , each in their own subdirectory.
-Need to run a script against all files and append data to a single CSV after parsing elements from these files.
My thoughts are to use an identifier from each xml to append to a new line(They have unique ID numbers) , starting with the first item, then append the rest of the data from that report to the same line. Then, using a ForEach loop, parse through the rest of the $items in $directory. The data in the XML is appended to a specific $column dependent on the xml element.
Does this sound like the best approach? Can ForEach do this?
Opinions welcomed! Thanks in advance.