Topic
2 replies Latest Post - ‏2013-09-04T17:42:16Z by Jim Divoky
PokerChris
PokerChris
5 Posts
ACCEPTED ANSWER

Pinned topic Passing a String to a Functional Map

‏2013-08-26T15:58:20Z |

I'm creating a functional map where I have a x12 file as my input and an address database table as my output.

 

The addresses can be of many different types (home, work, school, other, etc.)  There is a field on the db table to capture the type as well.

 

The issue I'm running into is that I have to create a different functional map for each type.  What I would prefer to do is make one functional map and as an argument to that map, pass in a string value of 'H' for home, 'W' for work, etc.  However, when I try to pass a string into the functional map, the functional map wizard doesnt recognize it and wont let me create the map.

 

Is there a way to accomplish this so that I can create one functional map instead of many to accomplish this task?

Updated on 2013-08-26T15:58:46Z at 2013-08-26T15:58:46Z by PokerChris
  • Bhoju
    Bhoju
    37 Posts
    ACCEPTED ANSWER

    Re: Passing a String to a Functional Map

    ‏2013-08-27T08:25:34Z  in response to PokerChris

    there are ways you can give a try

    1. If wizard is creating problem, create functional map manually.

    2. Create one functional map and pass filtered data to functional from executable map e.g. from executable map use extract function to pass only those records where say address type = 'H' etc and call functional map multiple times from different rule bars of executable map. Assuming you have an identifer in the record which tells what kind of address it is.  (offcourse you are not deciding it yourself)

    3. Functional maps perfectly allows two input cards only thing is, if both records are variable then the functional map get taken the cartesian production of both record occurances and get executed that many times.

    I hope it helped. Good luck

     

     

  • Jim Divoky
    Jim Divoky
    20 Posts
    ACCEPTED ANSWER

    Re: Passing a String to a Functional Map

    ‏2013-09-04T17:42:16Z  in response to PokerChris

    You have to provide a valid type tree reference for the string item to the functional map wizard.  Select the offending item in the wizard.  It will be highlighted with a yellow non-smiling smiley.  Click on the Edit command button. Specify a suitable text object in an available type tree.  Click on OK and the problem object should now be highlighted by a green smiley.  Click on the Create button and you should now have a FMap containing the string object you need.

    See attachment for images of the FMap Wizard steps.