Split Records based on field change mapping udf or standard function

[Former Member]

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

[manoj_khavatkopp · Accepted solution]

Ram,

Follow as below :

Br,

Manoj

[Former Member · Accepted solution]

Thank you Manoj! It worked for me.