Rank: Newbie
Joined: 11/2/2009
Posts: 2
Location: cinti, Ohio
|
I'm still learning the MapForce tool, but I've been unable to find a way to provide what I need. All of the lookup examples I've seen share the fact that the function has to know the target of its results, because it has to place the result in a structure.
I'm really trying to make a higher performance version of a value-map, where I put criteria in, and get a string value out, that I can reuse and place the result on any target.
There are several nice examples of ways to do the lookup I want,(find the value in a conversion table), but I can't seem to find a way to return a simple string from my User Function. (so I can reuse it)
ejohann attached the following image(s):
|
Rank: Advanced Member
Joined: 12/13/2005
Posts: 551
Location: Mauritius
|
The solution in you case is to connect pplusFieldValue to the "table" input of WHERE component. In this case the "result" of WHERE is this field value.
Vlad
|
Rank: Newbie
Joined: 11/2/2009
Posts: 2
Location: cinti, Ohio
|
Thank you for the quick reply. Let me be sure I understand it.
Are you saying I can replace the table connected to the sql-where with just the field I want to return? Does the WHERE process infer the table to filter from the container of the field connected to the Table connector?
Is there any reference information on some of these functions? It would be very helpful to understand the various ways powerful functions like this can be used.
Eric
|
