Skip to Content
0
Former Member
Mar 15, 2007 at 01:18 PM

Mapping Help/UDF needed.

6 Views

Hi my source looks something like this

-


Recordset. 0-Unbounded.

-


Record 0-Unbounded

-


Value1

-


Value2

-


DOCNO

-


MatNo

target

=====

MT_Target

-


Recordset 0-Unb

-


Header

-


Val1

-


Val2

-


DOCNO

-


Material 0-Unb

-


Matno

Example Mapping

=============

-


Recordset. .

-


Record

-


XXX

-


YYY

-


100

-


01

-


Record

-


XXX

-


YYY

-


100

-


02

-


Record

-


AAA

-


ZZZ

-


200

-


22

-


Record

-


AAA

-


ZZZ

-


200

-


33

Then My Target would be like

MT_Target

-


Recordset

-


Header

-


XXX

-


YYY

-


100

-


Material

-


01

-


02

-


Recordset

-


Header

-


AAA

-


ZZZ

-


200

-


Material

-


22

-


33

Please notice the Grouping of DOCNo and Corresponding material numbers

So I am trying to group the Materials in the Target structure based on the DOCNO field. So all the materials falling under the same DocNo are listed under that DOCNo,Like if Matno 01,02 fall under Docno 100 so they are listed Under DOCNO :100

So if there are 3 DOCNo’s then we will have 3 Recordset in the target and each Recordset will have the corresponding MATNO for that DocNo. Hope u understand.

Could anybody please help me out with this, I have tried using SplitByValue Changing and Collapse Conetxt, it works for the Header but not for the "Material" Node. Help needed, Points Guaranteed.