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?