Combine XML files and load into excel

Tình trạng: Closed
Giải thưởng: $25
Các bài thi đã nhận: 23
Người chiến thắng: minametry903

Winner

Tóm tắt cuộc thi

I have 18 XML files with a large amount of data. The 18 files need to be combined into a single Excel sheet.

Each XML file has a number of embedded tables / trees that need to be expanded into a single table in the Excel sheet.

The structure of all XML files is the same. the 'prime key' field is the 'identifier' (eg E 04/1169). Each XML file contains approximately 990 of these.

An example of two of the 18 files is attached.

In order to demonstrate your capability, please show;
- A screenshot of the file extracted into excel
- note the number of fields extracted (column numbers)
- note the number of records extracted (row numbers) once you have expanded into one table and combined the two files
- include some comments describing your method for combining the 18 files into 1 XLSX file, noting what software you use.
- A link to the example file in google docs / dropbox or similar.

It is possible the combined table will generate more than 1,000,000 rows. This means it may need to be done in a Power Query Data model or similar.

Các kĩ năng yêu cầu

Winner

Đăng cuộc thi giống như cuộc thi này

Phản hồi của người thuê

“A job well done by Mina M. Look forward to working with him again. ”

nomilknosugar, Australia.

Những bài dự thi tốt nhất dự cuộc thi này

minametry903 Egypt

0
MinagaPasandul1 Sri Lanka

0
amirulislam750 Bangladesh

0
husni818 Indonesia

0
zohaerisum14 Bangladesh

0
apatil101 India

0
shamimhossein Bangladesh

0
shamimhossein Bangladesh

0
StrongDecs Ukraine

0
rupinderhanda India

0
muzammilahmad27 Pakistan

0
muzammilahmad27 Pakistan

0
BabuPC333 Bangladesh

0
BabuPC333 Bangladesh

0
badarudinchishti Pakistan

0
minametry903 Egypt

0

Xem thêm bài dự thi

Bảng thông báo công khai

BabuPC333
- cách đây 1 tháng
Please see my entry #16 and #17
- cách đây 1 tháng
Chủ cuộc thi
- cách đây 1 tháng
Please also comment whether you think this should go into an Excel powerquery data model, or can be a simple excel sheet
- cách đây 1 tháng
1. minametry903
  - cách đây 1 tháng
  You can edit and modify what every you want? All data of the XML file i did convert fully to excel and it could be a good excel one as a source of data for you. I explained to you fully on my entry #9 all the details of the converted file and added one more entry #10 to show you how you can filter and get the data of file. The number of columns in excel are 226 and the number of rows are 100326, some are empty and you can adjust delete or edit what you want, but it was converted from the XML file. You can check my entry and i can do whatever you ask me to do or extract, i worked on excel 12 years
  - cách đây 1 tháng
2. minametry903
  - cách đây 1 tháng
  yes it could be power query t get any data you want and you can sort it as you want
  - cách đây 1 tháng
Chủ cuộc thi
- cách đây 1 tháng
In your response, please show me the total number of fields to go into the excel output.
- cách đây 1 tháng