ABinitio- how to get/return first not null column from a list of columns

589 views Asked by At

I am new to ABinitio, need help : I have 6 columns with address fields , trying to find function in Abinitio which returns first not null value taking list of columns as arguments(something similar to Coalesce in Teradata or NVL in Oracle)

my requirement : should return first non null column value from this (col1,col2,col3,col4..)

1

There are 1 answers

0
Chorel On

It's 3 month old, but in case somebody else looks for the same:

first_defined(col1, col2, col3, col4, col5, col6, default_value_if_you_need_it);