EVL – ETL Tool

Products, services and company names referenced in this document may be either trademarks or registered trademarks of their respective owners.

Copyright © 2017–2023 EVL Tool, s.r.o.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts.

Table of Contents

Other Functions


(since EVL 2.8)


return first object which is not null. Last value in the list can be fixed value.

For example following example can be used in mapping:

out->value = first_not_null(in->value_field1, in->value_field2, in->value_field3);

which means that in output ‘value’ will be assigned ‘value_field1’ if it is not null, otherwise ‘value_field2’ if it is not null, otherwise ‘value_field3’ (even if it is null).

Example with default value:

out->value = first_not_null(in->value_field1, in->value_field2, in->value_field3, "N/A");

which is the same as previous example, except in case also ‘value_field3’ is null, then string ‘N/A’ is assigned to ‘*out->value’.