Omit missing fields in a Mapper

Question

Hi community,
I would like to create a Master Mapper of sorts that will accept an input stream of let’s say field1 and field2, and just output those fields.

Mapper:
 TEST_MasterMapper_2020_02_11.slp (4.9 KB)
I’ve uploaded a sample pipeline of what I would like to achieve.
Thanks everyone in advance!

dmiller · Answer

I’m trying to understand the ask. Are you saying you want a kind of universal Mapper configured to accept  n number of fields, but if a field is not in the input, not to write that field to the output (instead of writing it with a null value)?

philliperamos · Answer

That’s correct.
I essentially have 25+ data sets to extract from a source system, and from those data sets, there are about 50 common fields.
Hence, a master mapper with the common fields, that will ignore the ‘missing’ fields.

cjhoward18 · Answer

philliperamos:

TEST_MasterMapper_2020_02_11.slp

In your example pipeline given, if you enable the Null-safe access in the mapper, then attach another mapper at the end with the expression: $.filter((value, key) =&gt; value != null) mapped to the target: $ will give you all the values of your common mappings that are not null.

Forum Discussion

Omit missing fields in a Mapper

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?