Is a "Load Inline" the correct solution here?

[Anonymous]

Hi,

I have loaded several fields with sql-Select commands. There ist one field containing 3 to 8-digit numbers. From theses numbers, only the third digit from the left of each number is relevant for me, because it represents a certain location.

My goal is to represent this information in a way that is readable for the end-user, e.g. if the third number is a 7, then the corresponding location is displayed.

My first guess was to use a "load inline" command. I have extracted the third digit with "Mid(MUNICIPAL_KEY, 3,1)" , so that my Listbox only shows these digits. But now I am not able to use these values in a "load inline" section.I have to admit that I really don't know if that is the proper way to go...

I hope that the explanation of the problem is understandable. Thanks in advance for any help....

Best Regards, Markus

[swuehl]

Depends on how you want to build your data model. But an INLINE LOAD should probably work.

For example, using a MAPPING approach to map your texts:

MAP:

MAPPING

LOAD * INLINE [

Digit, Text

7, Location A

];

LOAD *,

      ApplyMap('MAP',Mid(MUNICIPAL_KEY,3,1), 'no Map') as Text;

SQL SELECT MUNICIPAL_KEY

FROM ...;