Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ...;