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

[Former Member]

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.

[Former Member · Accepted solution]

I have resolved this by writing UDF to add child node.

Thanks,

Vertika

[former_member190293]

Hi Vertika!

Does your source file structure look exactly like above? With "Header", "Employee" and "Time" rows?

Regards, Evgeniy.

[Former Member]

Yes it has

Header      000

Employee  002

Employee  002

Header      000

Employee  002

Employee  002

Header      000

Time          003

Time          003

Time          003

Time          003

Time          003

[Former Member]

Also in target structure we don't need all headers. We can keep just first header.

[former_member190293]

And what is the field separator?

Regards, Evgeniy.

[Former Member]

This is fixed length file.

[former_member190293]

Hi Vertika!

You can use File Content Conversion in sender File adapter to get XML structure for your source flat file and then use mapping to assign Time values for each Employee.

Regards, Evgeniy.