The XML Converter parses and reconstructs XML data into a single flat table, or multiple tables that can be joined using a generated unique identifier.
item_name | item_id | type | ppu | batter_id | batter | topping | topping_id | filling_id | filling_name | addcost | |
---|---|---|---|---|---|---|---|---|---|---|---|
Cake | 1 | donut | 0.55 | 1001 | Regular | ||||||
Cake | 1 | donut | 0.55 | 1004 | Devil's Food | ||||||
Cake | 1 | donut | 0.55 | Glazed | 5007 | ||||||
Cake | 1 | donut | 0.55 | Chocolate with Sprinkles | 5006 | ||||||
Bar | 4 | bar | 0.75 | 1001 | Regular | ||||||
Bar | 4 | bar | 0.75 | Chocolate | 5003 | ||||||
Bar | 4 | bar | 0.75 | Maple | 5004 | ||||||
Bar | 4 | bar | 0.75 | 7001 | None | 0 | |||||
Bar | 4 | bar | 0.75 | 7002 | Custard | 0.25 | |||||
Bar | 4 | bar | 0.75 | 7003 | Whipped Cream | 0.25 | |||||
Twist | 5 | twist | 0.65 | 1001 | Regular | ||||||
Twist | 5 | twist | 0.65 | Glazed | 5002 | ||||||
Twist | 5 | twist | 0.65 | Sugar | 5005 | ||||||
Filled | 6 | filled | 0.75 | 1001 | Regular | ||||||
Filled | 6 | filled | 0.75 | Chocolate | 5003 | ||||||
Filled | 6 | filled | 0.75 | Maple | 5004 | ||||||
Filled | 6 | filled | 0.75 | 7002 | Custard | 0 | |||||
Filled | 6 | filled | 0.75 | 7004 | Strawberry Jelly | 0 |