How do I add a column to one dataset from another?

[wildbeastinc]

I have an XML source file and I need to place values from it into database tables. The issue is that I want to use one of the values as a value in multiple tables. How do I get access to use the field more than once? I am able to read that portion of the xml to a table, but I can not figure out how to access that field again and place it in another table with another portion of the xml file. The example below will help describe my issue. I want to be able to add a column to a Models table that uses RSID as a column. Models includes name, val, and count - and I want to add a column to the table with the RSID value.

Any help is appreciated.

<Solution>
<Specifications>
<SessionData RSID="87E06073EF654256A2A5ED7DBADBB7E7" RSITER="1" BLUEKEY="1" />
</Specifications>
<Results>
<FinancialResults>
<ModelsTotal Val="19867">
<Product Name="BCS BLc3000 CTO Enclosure" Val="3933" Count="1" />
<Product Name="HP BLc3000 Onboard Admin FIO" Val="799" Count="1" />
<Product Name="HP BLc 1/10Gb VC-Enet Module Opt Kit" Val="11398" Count="2" />
<Product Name="QLogic QMH2462 4Gb FC HBA for HP c-Class BladeSystem" Val="749" Count="1" />
<Product Name="HP Single Active Cool fan option Kits" Val="894" Count="6" />
<Product Name="HP 1200W AC Power Supply" Val="2094" Count="6" />
</ModelsTotal>

 

[dodge20]

I would create a variable to store the data. You can write an expression that will populate the variable with your rsid, then it can be used anywhere within the package.

Dodge20