Want to generate target structure based on the comparing of records source

[Former Member]

Hi Experts

i hava an issue here

I want to generate target sturecture

My requirement is

Source Target

-

---

-

---

LPLRecordset PurchaseRecordset

a a

b b

c c

d d

Tax(Subrecordset 1

1 2

2

If LPL data is coming it need to populate Purchase Record fields... if tax is coming then it need to populate with LPL with Tax ,

If tax Recordset is coming twice it need to populate Purchase Recordset ..

Plz hep me in this

how to populate the target , If possible with eg

[Former Member]

No one answered

[Former Member]

Not satisfied no one replyed

[Former Member]

Source

-

---

LPLRecordset

a

b

c

d

Tax(Subrecordset

1

2

Target

-

---

PurchaseRecordset

a

b

c

d

1

2

If LPL data is coming just it should populate a,b,c,d

If Tax data is coming it need to populate whole purchase record but only 1,2

if tax data is repeating 2 times it should populate whole purchase record twice with only tax data populate in the target

How to map from source to target

Reply me back if you have any queies

[Former Member]

Source Target

-

---

-

---

LPLRecordset PurchaseRecordset

a a

b b

c c

d d

Tax(Subrecordset 1

1 2

2

This is the actual structure