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...
Problem in XML input Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
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.
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.
Regards,
S. Kirtikumar.
S. Kirtikumar.