Integration Formatting Question

[timroop]

Currently we use integration formats that have one line per employee with the columns being set as deduction or paycodes. Example

EmpID      Miles   Insurance  hours
Employee1  1234     34.23     0
Employee2  0        45.21     40

We have a new client that uses a system that is only able to generate reports with one pay or deduction code per line. For example:

Employee1 miles 1234
Employee1 insurance 34.23
Emplyeee2 hours 40
Employee2 insurance 45.21
With my limited experience with IM I am uncertain if this type of integration can be done.

Any input would be helpful.


Tim Roop
"If you can do something about it, why waste time getting upset? If you can't do anything about it, why bother getting upset on top of it? -Shantideva

 

[greatplainspro]

you need to create two sources using the same file that stores the info you posted above. In other words, one file is for summary data (employee1 or employee2) and the other file will be detail (miles1234 or hours1234 or insurance1234, etc).

You need to group the summary file by employee# and then create a Query relationship by Employee#.

i can provide more detail if needed