topic Multiple applymaps in App Development

Multiple applymaps

deep2021 — Tue, 30 Nov 2021 18:17:33 GMT

Hi,

I have a number of applymaps in my script. Could you please help me out, how to write the applymaps with mapping load using subfield function.

Thanks,

Jayavignesh — Mon, 07 Jun 2021 11:02:45 GMT

You can pass the reference with subfield function in applymap.

ApplyMap('map_name', Subfield(field1,',')[ , default_mapping ] )

deep2021 — Mon, 07 Jun 2021 11:28:59 GMT

can you please share an example for the same?

Jayavignesh — Mon, 07 Jun 2021 11:37:05 GMT

Would be good if you share a qvf/qvw

marcus_sommer — Mon, 07 Jun 2021 11:47:09 GMT

To reduce the number of needed mappings in the case you need to apply more than one value you could string-concat the return values like:

m: mapping load LookupKey, F1 & '|' & F2 & '|' & F3 inline [
LookupKey, F1, F2, F3
1, x, y, z
2, a, b, c
];

and then you call them as an example with:

t: load *, subfield(applymap('m', LookupKey, 'default ...'), '|', 2) as F2
from Source;

- Marcus