B
bttrflii
i have a dataset exported to xml from a windows application that i'd like to
import into excel 2007. i can import the xml file ok, but my "child" tables
don't import in with their associated "parent" row.
to use a simplified example, suppose that i have a parent table of "parent":
id | name
-----------
01 | ann
02 | ben
03 | carol
i have several other tables that reference the people id column in a
many-to-one relationship, one of which could be "kids":
id | pid | name
--------------
01 | 01 | zach
02 | 01 | yvonne
03 | 01 | xyver
04 | 03 | william
i'm currently getting an import that looks like this.
ann
ben
carol
zach
yvonne
xyver
william
what i would like excel to do is display this information with the child
tables near the parent row that they're associated with, such as (hopefully
this is readable):
parent | kid
ann zach
yvonne
xyver
ben
carol william
is this possible? i have control over the xml from the windows application,
so that can be changed if needed. the data (but not the schema) is
constantly changing, so i can't nail any number of "parents" or "children"
down.
any help is greatly appreciated.
import into excel 2007. i can import the xml file ok, but my "child" tables
don't import in with their associated "parent" row.
to use a simplified example, suppose that i have a parent table of "parent":
id | name
-----------
01 | ann
02 | ben
03 | carol
i have several other tables that reference the people id column in a
many-to-one relationship, one of which could be "kids":
id | pid | name
--------------
01 | 01 | zach
02 | 01 | yvonne
03 | 01 | xyver
04 | 03 | william
i'm currently getting an import that looks like this.
ann
ben
carol
zach
yvonne
xyver
william
what i would like excel to do is display this information with the child
tables near the parent row that they're associated with, such as (hopefully
this is readable):
parent | kid
ann zach
yvonne
xyver
ben
carol william
is this possible? i have control over the xml from the windows application,
so that can be changed if needed. the data (but not the schema) is
constantly changing, so i can't nail any number of "parents" or "children"
down.
any help is greatly appreciated.