Problem in XML input Stage

[sengs]

Hi All,
I have a mapping which reads a file through folder stage and then an XMl input stage and we write to a data base. The hierarchy of elements is like this

<Privilege>
<User Value="newemail1@someagency.gov" />
- <ActionList>
<Action Value="View" />
<Action Value="Create" />
</ActionList>
- <Agency Value="AHC5598964441">
<Product Value="Product1" />
<Product Value="Product2" />
<Product Value="Product3" />
<Product Value="Product4" />
<Product Value="Product5" />
</Agency>
</Privilege>

Here when i choose the product value as the key column, then i get a set of records pertaining to either the Action value View or Create not both.
But i want all records that is for View different product values and for Create different product values in my target.
Please let me know how can i achieve this.

Thanks in Advance...

[Kirtikumar]

Here in your data you have data on which permutation and combination need to be executed.
I guess it can not be done using XML stage. Using two XML stages you can separate out Action Value and Product value. Then create a lookup for Action value. In the lookup add a dummy column with value '1' and then with Product value do a lookup with hardcoded value '1'.

This generate the multiple combinations of products and actions.