abraham30
11-07-2017, 07:42 AM
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
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