AnsweredAssumed Answered

Nested Identifier Instance implementation help

Question asked by britto.parthalomew on Mar 16, 2018
Latest reply on Mar 26, 2018 by britto.parthalomew

Hi folks,

 

As you are all aware xml identifier instance cannot be nested in Boomi. having said that how have you guys handled such cases if you had encountered. Presently I have such case and I wanted to hear from our folks on various approaches or any solution to below case.

I have an xml document with multiple parent child relations. I need to generate single document for each ID filtering out unwanted data. I need to use 2 conditions like 1. costdetail.costname equals to 2. costdetail.taxdetail.taxname equals to

Below is a sample data and expected output. Any help will be appreciated.

 

 

Sample Data
<CvObject ID="23234">
<CostDetail CostDetailId="75233B9B-75A2-4A70-8AAA-1BAFE8F31A2B" CostName="Actual" date ="2017/02/01"> (Unbounded)
<TaxDetail Tax="2.000000" TaxId="CEF154EC-6E1F-4482-A012-623CB99022F6" TaxName="VAT" TaxType="By Percentage"/> (unbounded)
<TaxDetail Tax="8.000000" TaxId="EEB9DC3B-7133-442B-86C1-C2126366A0F2" TaxName="Other tax" TaxType="By Amount"/>
<TaxDetail Tax="4.000000" TaxId="BBF94B3D-74EA-437F-80B9-CDA5C63B838C" TaxName="State tax" TaxType="By Percentage"/>
<TaxDetail Tax="5.000000" TaxId="AF374EE3-4C57-4C3D-929B-D1C853ACC5C7" TaxName="Occupancy tax" TaxType="By Percentage"/>
<TaxDetail Tax="1.000000" TaxId="2AE2E414-E63F-4581-950C-F5B1391A786C" TaxName="Service charge" TaxType="By Percentage"/>
</CostDetail>
<CostDetail CostDetailId="B2B7D179-CFC1-4859-BDA5-A3F6C0AAA16F" CostName="Final" date ="2017/02/03">
<TaxDetail Tax="3.000000" TaxId="CEF154EC-6E1F-4482-A012-623CB99022F6" TaxName="VAT" TaxType="By Percentage"/>
<TaxDetail Tax="6.000000" TaxId="EEB9DC3B-7133-442B-86C1-C2126366A0F2" TaxName="Other tax" TaxType="By Amount"/>
<TaxDetail Tax="2.000000" TaxId="BBF94B3D-74EA-437F-80B9-CDA5C63B838C" TaxName="State tax" TaxType="By Percentage"/>
<TaxDetail Tax="1.000000" TaxId="AF374EE3-4C57-4C3D-929B-D1C853ACC5C7" TaxName="Occupancy tax" TaxType="By Percentage"/>
<TaxDetail Tax="0.000000" TaxId="2AE2E414-E63F-4581-950C-F5B1391A786C" TaxName="Service charge" TaxType="By Percentage"/>
</CostDetail>
</CvObject>

 

Expected Output
ID|ActualDate|Actualtax1|Actualtax2|Actualtax3|Actualtax4|Actualtax5|FinalDate|Finaltax1|Finaltax2|Finaltax3|Finaltax4|Finaltax5
23234|2017/02/01|2.0|8.0|4.0|5.0|1.0|2017/02/03|3.0|6.0|2.0|1.0|0.0

 

Adam Arrowsmith Srinivas Chandrakanth Vangari

 

Note:

Split by TaxDetails and loading to cache and referring in map does not seem to be working logically

 

Thanks in advance

Britto

Outcomes