capture few columns from xml file

[abraham30]

Hello Everyone

I want to capture only few columns from 5000 XML file available in a folder as there is a performance issue in capturing all columns.

I have attached the macro with data for your reference (attaching notepad by copying data from XML file).
I am getting lot of blank records during importing which I required to clean it along with repetition of column for every import of xml file.

My requirement is
1) To capture the text value for the defined column if present else skip the records using certain condition.
2) Create the column name as ID12, INW1, INY5, IXStudy in the first row of sheet 1
3) Delete blank rows

I google the requirement and use it for reference. Can you please help

[abraham30]

Dear Expert,

Can you please help me as I am struggling to clean data.

I am trying to import few XML files (Reference file in sheet2) from a location and it was not cleaned properly. Also there is a huge performance issue in the macro.


I want the keep the output something like in sheet 3.


Thanks in advance for your help

[snb]

Can you post a sample XML-file ?
The data you posted didn't constitute a valid XML-file.

[abraham30]

Thanks snb. please check the XML file in sheet2 (Reference_XML).

I want the output like available in sheet3. I tried all possible combination but its not working.

[snb]

An XML file can't be contained in an Excel file.

[Jan Karel Pieterse]

Of course it can.

[snb]

Does this solve TS's question ?

[abraham30]

Ok, I have attach once again within document. You can cut and paste in any place as the XML file is not supporting to upload in this forum.

Thanks

[snb]

You can always zip an xml-file and upload.

[abraham30]

Thanks snb for your guidance.

Please check once