on 02-04-2009 8:08 AM
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
Hi,
Kindly provide the source and target structure and their respective occurrences. Maybe this can be resolved without UDF.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.