cancel
Showing results for 
Search instead for 
Did you mean: 

Count of Target fields

Former Member
0 Kudos

Hello gurus,

I am doing a scenario where I have one input file with several Recordsets and i need to split the file based on Company Code.My output structure has Hearder,Data and Footer.I have achieved this.

I also need to count the number of times the Header,Data and Footer comes in output file and then add all of them and also add the Index.I need to map this to one of the target field.

Can you please guide me as to how I should proceed.

Thanks in Advance,

Swathi

Accepted Solutions (0)

Answers (2)

Answers (2)

markangelo_dihiansan
Active Contributor
0 Kudos

Hi,

Kindly provide the source and target structure and their respective occurrences. Maybe this can be resolved without UDF.

Regards

Former Member
0 Kudos

Hi,

Use the std. fun. "Count" for this.

All Source fields (map into corresponding input box) --->RemoveContext -


>Count -


>UDF(write a code which will have n number of input box and then write the code to sum all the values from dirrerent sources) ---> Target.

Regards,

Sarvesh