Need help with writing an XSLT

[davkaplan]

Hi

I'm looking to write a XSLT that could transform a set of XML data (please see DBDump.xml in zip attached) but am having immense trouble doing so.

I have also attached a schema of how the output data should be structured and my current XSL (which is totally wrong).

I'm trying to create the following structure from the XML data:

<PartMappings> node
- <RFQLevel> elements grouped by the RFQLEVEL_PARTTYPE_ attr from the XML
-- A list of <ProductLevel> child elements under each <RFQLevel using the PRODUCTLEVEL_PARTTYPE_ attr

Additionally:
<QuestionMappings> node
- <RFQLevel> elements grouped by the RFQLEVEL_QUESTIONREF_ attr from the XML
-- A list of <ProductLevel> child elements under each <RFQLevel using the PRODUCTLEVEL_QUESTIONREF_ attr

I'm very new at all this - any help would greatly be appreciated!

Thanks,
David