Support | Blog | Contact Us
Trifacta SaaS
Release 7.1
Release 6.8
Release 6.4
Release 6.0
Release 5.1
Release 5.0
Trifacta Wrangler free
Schedule Enterprise Demo
Feedback
Trifacta.com
changes.mady.by.user docuser1
Saved on Feb 06, 2018
Saved on Nov 06, 2018
...
derive type:single value: COALESCE([col1,col2,col3]) as: 'firstValue'
Output: Generates the firsValue firstValue column, which contains the first non-missing detected in col1, col2, or col3 in that order.
firsValue
firstValue
col1
col2
col3