Originally posted by: Karthik12r

I have two input cards with group occuring S times. I need to pass these groups to group in output card which is also s times.

Say for example, I have 10 names in input #1  and  10 marks in input # 2, i need to get output like a marksheet ,  Name = Mark. For this my functional map should run 10 times. But if i pass input 1 and 2 as arguements to fun map, it runs 10*10 100 times. how do i get this done using indexing or other technique. Request suggestion.
 

Originally posted by: paul.brett

For a marksheet (table) output, you only need to alter the syntax of the delimiters:

001aaa | 001bbb | 001ccc | 001ddd | 001eee | 001fff | 001ggg | 001hhh | 001iii | 001jjj
002aaa | 002bbb | 002ccc | 002ddd | 002eee | 002fff | 002ggg | 002hhh | 002iii | 002jjj
003aaa | 003bbb | 003ccc | 003ddd | 003eee | 003fff | 003ggg | 003hhh | 003iii | 003jjj
004aaa | 004bbb | 004ccc | 004ddd | 004eee | 004fff | 004ggg | 004hhh | 004iii | 004jjj
005aaa | 005bbb | 005ccc | 005ddd | 005eee | 005fff | 005ggg | 005hhh | 005iii | 005jjj
006aaa | 006bbb | 006ccc | 006ddd | 006eee | 006fff | 006ggg | 006hhh | 006iii | 006jjj
007aaa | 007bbb | 007ccc | 007ddd | 007eee | 007fff | 007ggg | 007hhh | 007iii | 007jjj
008aaa | 008bbb | 008ccc | 008ddd | 008eee | 008fff | 008ggg | 008hhh | 008iii | 008jjj
009aaa | 009bbb | 009ccc | 009ddd | 009eee | 009fff | 009ggg | 009hhh | 009iii | 009jjj
010aaa | 010bbb | 010ccc | 010ddd | 010eee | 010fff | 010ggg | 010hhh | 010iii | 010jjj

...and yes, the map does have embedded functional maps, and you will see 100 iterations (for 2 lots of 10 inputs).

Perhaps I have misunderstood the requirement.  Could you alter the enclosed inputs and tell us what you're expecting as the output?

Thank-you.

Paul

Follow me on Twitter

Attachment(s)

Marksheet.zip   10 KB 1 version

Originally posted by: DeM0n

I guess that this is what you want to do...Please see the attached example...

Attachment(s)

Marksheet.zip   6 KB 1 version

Originally posted by: Karthik12r

Great,  this is what i was looking for. This satisfies my requirement. I will take it from here for my requirements... thank you so much for the help.

Originally posted by: DeM0n

Even this rule will work. This is more efficient that the one I provided earlier......

=F_Input1(LOOKUP(TextItem:In1,INDEX(TextItem:In1)=INDEX(TextItem:In2)),TextItem:In2)

Also, you can use INDEXABS instead of INDEX...depends on your requirement.....