topic Re: Map ... Using; why doesn't this work? in App Development

Map ... Using; why doesn't this work?

stascher — Sat, 16 Nov 2024 21:40:00 GMT

Hello.

I'm trying to mask the values in a field by reading the original set of values, creating replacement values based on record position and then employing Map Using to change the values whenever they're read in. Here is the code I'm trying to use, but I'm not seeing any changes in the data. Any idea why?

Subject_List:
load distinct [Subjects.Subject] as Original_Subject,
'Subject_'&rowno() as Masked_Subject
from [lib://Subjects.qvd](qvd);

Subject_Mask:
mapping load Original_Subject, Masked_Subject resident Subject_List;

drop table Subject_List;

map [Subjects.Subject] using Subject_Mask;

Test:
Load [Subjects.Subject] from [lib://Subjects.qvd](qvd);

I would expect the values in Test to be 'Subject_x'.. but they're the original values.

Thanks for any assistance.

Re: Map ... Using; why doesn't this work?

marcus_sommer — Thu, 03 Jan 2019 14:22:10 GMT

Try it with any kind of enforcing a processing of the data, for example with something like:

...
Test: Load [Subjects.Subject] from [lib://Subjects.qvd] (qvd) where 1=1;

- Marcus

Re: Map ... Using; why doesn't this work?

stascher — Thu, 03 Jan 2019 14:46:45 GMT

Wow that worked. I never would have guessed that in a million years. You really are an MVP Marcus.

Thank you.

Re: Map ... Using; why doesn't this work?

marcus_sommer — Thu, 03 Jan 2019 14:54:39 GMT

Thanks. Beside the mapping-topic I think you could also use:

'Subject_'&autonumber([Subjects.Subject])

to simplify the task.

- Marcus