Skip to Content
0
Former Member
Jun 13, 2017 at 12:45 PM

Split Records based on field change mapping udf or standard function

106 Views

Hi Experts,

My Requirement is follows: Whenever the CompanyID value gets change, there need to be new "Record" getting created in Target Structure.

Could any one suggest UDF/Standard Function for this requirement.

Each row contains CompanyID and Location:

Source Structure

row(1..unbounded)

--CompanyID

--Location

--Name

Target structure:

--Record(1..unbounded)

----Header(1..unbounded)

--CompanyID

----Item(1..unbounded)

--Location

--Name

Output Result: Say for e.g:

Record1

Header

--CompanyID-1000

Item1

--Location: NYR

--Name: abc

Item2

--Location: GLY

--Name: bcd

Record2

Header

--CompanyID-2000

Item3

--Location: BKR

--Name: def