Originally posted by: SystemAdmin

Hello! This is for the Windows 6.7.1 version.

Have an input file gouped by SSN with one PRSN main record and 1 to many PROP records for coverage.

The output is mapped from both input record types. Need to create possible many output records for the same SSN depending on the number of PROP records it has and also use a specific PROP record to build the output too.

For example SSN 111111111 has
PRSN 111111111 Name
PROP 111111111 Yesterday
PROP 111111111 Today
PROP 111111111 Tomorrow

The output should look like
111111111 Name Yesterday
111111111 Name Today
111111111 Name Tomorrow

SSN 222222222 has
PRSN 222222222 Name
PROP 222222222 Yesterday
PROP 222222222 Today

The output should look like
222222222 Name Yesterday
222222222 Name Today

The COUNT function returns the number of PROP records for and input SSN group and was looking to use that number to somehow run the functional map COUNT number of times, but the first call should send PRSN and PROP record 1, the second call should send PRSN and PROP record 2 and so on for the number of PROP records in the input SSN group to be mapped.

The current functional map call looks like

F_Map_Output(SSN_Detail_Group, COUNT(PROP_Record:SSN_Detail_Group)

This will need to be changed or enhanced but not sure of the way to do this to achive the goal. possibly to something like

F_Map_Output(SSN_Detail_Group, COUNT(PROP_Record:SSN_Detail_Group), PROP_RecordCount - n:SSN_Detail_Group)

Would very much much appreciate any help and possibly a sample map and tree in or to do this.

Thanks!


#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Hi,

Instead of keeping the COUNT function,You can call the Functional Map multiple times with the PROP record.Since You need the PRSN Record data also in the next level,pass PRSN record data along with the function call

=F_EACHPROP(PROP:SSN,PRSN_ITEM:PRSN:SSN)

where PROP:SSN is PROP record in the input and PRSN_ITEM:PRSN:SSN is PRSN Record Data("Name" in your example)

I have created a map according to your scenario and attached with this post.

Please see the attachment for details.

NOTE: The map can process input files with multple SSNs.Version :6.7

Thanks,
Deepthi

#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Sorry,Missed the attachment
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender