Forum Discussion

sunil_murthy's avatar
sunil_murthy
New Contributor
8 years ago

How to Fetch all records while validating snap :

how to fetch all records in filereader snap while validating pipeline ? means i have 600 rows in a excel which i need to get in output view of filereader snap which is followed by a Excel parser ??...
koryknick's avatar
koryknick
Employee
4 years ago
Copy LinkReport

Technically, this could have been accomplished with a single Mapper expression, but I thought the JSON Splitter would make it a little easier to understand the Object.mapKeys() expression.

  • stephenknilans's avatar
    stephenknilans
    Contributor
    8 years ago
    Copy Link

    You can use a mapper with the nullsafe option turned on, and specify the fields that you need on the source and target. That should give you a null value. You can also simply replace the source value with a string like:

    ((‘LAST_NAME’ in $)?$LAST_NAME: null)

    This is basically two commands:

    1. (X in Y) which returns true if X is in Y. $ means the variables in this path.
    2. (X ? Y: Z) which means that if X is true then Y else Z