Skip to Content
0
Former Member
Jul 20, 2016 at 09:23 AM

Create nested structure when header and line column has same employee number

36 Views

Scenario: File to proxy

Below is example of Source Layout and required target proxy structure:

There will be unique employee entry in file and and for each employee there could be one or more Time entry.

I want to create nested proxy Employee-->Time where each employee will have corresponding Time records.

Header

000 07202016

Employee

002 Emp1 EmpName1

002 Emp2 EmpName2

Header

000 07202016

Employee

002 Emp3 EmpName3

002 Emp4 EmpName4

Header

000 07202016

Time

003 Emp1 EmpName1 100.00

003 Emp2 EmpName2 300.00

003 Emp1 EmpName1 50.00

003 Emp3 EmpName3 50.00

003 Emp4 EmpName4 100.00

003 Emp1 EmpName1 100.00

003 Emp4 EmpName4 200.00


Target Should have nested Time nested inside Employee


Header

Employee

002 Emp2 EmpName2

Time

003 Emp1 EmpName1 100.00

003 Emp1 EmpName1 50.00

003 Emp1 EmpName1 100.00

Employee

002 Emp1 EmpName1

Time

003 Emp2 EmpName2 300.00

Employee

002 Emp3 EmpName3

Time

003 Emp3 EmpName3 50.00

Employee

002 Emp4 EmpName4

Time

003 Emp4 EmpName4 100.00

003 Emp4 EmpName4 200.00

Please let me know easier way to handle this.