ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel datamap question (https://www.excelbanter.com/excel-programming/394762-excel-datamap-question.html)

[email protected]

Excel datamap question
 
How do I use the mapping tool with the following worksheet and data
map? I cannot figure out where I should drag the elements onto the
worksheet. Everything I tried results in an error when I try to export
to xml. When I bring the datamap into Excel, it shows the Department
and Division nodes as repeating, which I believe is what I want. In a
database, I would have a Divisions Table that is a child of the
Departments Table.

Department Employees Division Manager Employee
IT 45 Support BC Sam Smith
IT 45 Support BC Tom Jones
IT 45 Networks AB Bill Thomas
IT 45 Networks AB John English
Accounting 7 Payroll TG Sue Johnson
Accounting 7 Payroll TG Larry Neilson
Accounting 7 Receivables GR Harry Feldman
Accounting 7 Receivables GR Stan Simon



<Departments
<Department
<DepName</DepName
<Employees</Employees
<Divisions
<Division
<Name</Name
<Manager</Manager
<Employee</Employee
</Division
<Division
<Name</Name
<Manager</Manager
<Employee</Employee
</Division
</Divisions
</Department
<Department
<DepName</DepName
<Employees</Employees
<Divisions
<Division
<Name</Name
<Manager</Manager
<Employee</Employee
</Division
<Division
<Name</Name
<Manager</Manager
<Employee</Employee
</Division
</Divisions
</Department
</Departments



All times are GMT +1. The time now is 10:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com