- Data Type
- Operators
- Mathematical Functions
- String Functions
- Date/Time Functions
- Sequence Functions
- Table Sequence Functions
- Loop Functions
- Functions for Associative Operations
- File-handling Functions
- Database Functions
- Cursor Functions
- Statements
- System- & interface-related Functions
- Cluster Computing Functions
- Chart-plotting Functions
- External Library Functions
- Composite-Table-Related Functions
- Remote-service-related functions
- Simple SQL
-
Functions
- #c
- $(d)dql...
- $(db)sql;…
- ${macroExp}
- =expression
- >statement
- [a:b]
- @
- @x:…
- A()
- A.( x,… )
- [a 1 ,…a n ]
- abs()
- acos()
- acosh()
- age()
- align()
- ali_open()
- ali_close()
- ali_query()
- alter()
- and()
- append()
- argpost
- array()
- asc ()
- asin()
- asinh()
- atan()
- atanh()
- attach()
- avg()
- base64 ()
- between ()
- bi()
- bits()
- bit1( x )
- bit1( x,y )
- blob()
- bool ()
- break {a}
- C
- Cr()
- calc()
- call()
- call path/spl( … )
- calls path/spl( … )
- callx()
- cand()
- canvas()
- case()
- ceil()
- cellname()
- ch.()
- channel()
- char()
- chardetect()
- charencode()
- chi_p()
- chi2inv()
- chn()
- clear
- clipboard()
- close()
- cmp()
- cor()
- comabs()
- comangle()
- combin()
- comconj()
- comexp()
- comimage()
- commit()
- compair()
- complex()
- comreal()
- comsign()
- comstr()
- comunwrap()
- concat()
- conj()
- connect()
- contain()
- corskew()
- cos()
- cosh()
- count()
- cov()
- covm()
- create()
- cs.()
- cum ()
- cursor()
- date()
- datederive()
- dateinterval()
- datetime()
- day()
- days()
- decimal()
- delete()
- deq()
- derive()
- det()
- diff()
- digits()
- directory()
- dis()
- dism()
- dql()
- dup()
- dynadb._close()
- dynadb.execute()
- dyna_open()
- dynadb._query()
- dynadb.table()
- E()
- E()
- elapse()
- elasticnet()
- end s
- enum()
- env()
- eq()
- error()
- eval()
- es_close()
- es_delete ()
- es_export ()
- es_head ()
- es_open ()
- es_get ()
- es_post ()
- es_put ()
- exec()
- execute()
- exists()
- exp()
- export()
- eye()
- f@o(…)
- Faccrint()
- Faccrintm()
- fact()
- false
- Fcoupcd()
- Fcoups()
- Fdb()
- Fddb()
- Fdisc()
- Fduration()
- fetch()
- field()
- file()
- filename()
- fill()
- find()
- Fintrate()
- finv()
- Firr()
- fisher_p ()
- fjoin()
- float()
- floor()
- Fmirr()
- fname()
- fno()
- Fnper()
- Fnpv()
- for
- fork
- format()
- Fpmt()
- Fprice()
- Frate()
- Freceived()
- freq ()
- Fsln()
- Fsyd()
- ftp_cd()
- ftp_open()
- ftp_close()
- ftp_dir()
- ftp_get()
- ftp_mget()
- ftp_mput()
- ftp_put()
- func()
- Fv()
- Fvdb()
- Fyield()
- get()
- gcd()
- goto C
- group()
- groupi()
- groupn()
- groups()
- groupx()
- hash()
- hbase_close()
- hbase_cmp()
- hbase_filter()
- hbase_filterlist()
- hbase_get()
- hbase_open()
- hbase_rest()
- hbase_scan()
- hdfs_open()
- hdfs_close()
- hdfs_dir()
- hdfs_download()
- hdfs_exists()
- hdfs_file()
- hdfs_upload()
- hdfs_write()
- hive_open()
- hive_close()
- hive_cursor()
- hive_execute ()
- hive_query()
- hosts()
- hour ()
- httpfile()
- I()
- i()
- icursor()
- icount()
- id()
- if
- if()
- ifa()
- ifdate()
- ifind()
- ifn()
- ifnumber()
- ifpure()
- ifr()
- ifstring()
- ift()
- iftime()
- ifv()
- ifx_close()
- ifx_conn()
- ifx_cursor()
- ifx_listfrag()
- ifx_savefrag()
- ifx_setfrag()
- ifx_takefrag()
- import()
- impute()
- index()
- inf()
- influx_close()
- influx_insert()
- influx_open()
- influx_query()
- influx2_close()
- influx2_delete()
- influx2_open()
- influx2_query()
- influx2_rest()
- insert()
- int()
- interval()
- inv()
- inverse()
- invoke()
- isalpha()
- isdigit()
- isect()
- iselect()
- islower()
- isolate()
- isupper()
- iterate()
- j()
- join()
- joinx()
- json()
- jvm()
- k()
- kafka_close()
- kafka_commit()
- kafka_offset()
- kafka_open()
- kafka_poll()
- kafka_send()
- key()
- keys()
- kmeans()
- lasso()
- lcm()
- left()
- len()
- lg()
- like()
- linefit()
- lineplan()
- ln()
- load()
- lock()
- long()
- lower()
- m()
- mae()
- max()
- maxp()
- mcumsum()
- mcursor()
- md5()
- median()
- memory()
- merge()
- mfind()
- mi()
- mid()
- millisecond()
- min()
- minp()
- minute()
- mmean()
- mnorm()
- mode()
- modify()
- mongo_close ()
- mongo_open()
- mongo_shell()
- month()
- movefile()
- mul()
- mse()
- mstd()
- msum()
- mvp()
- n.f( x )
- name()
- new()
- news()
- next{a}
- nodes()
- norm()
- norminv()
- not()
- now()
- ntile ()
- null
- number()
- numnorm()
- nvl()
- o()
- olap_close()
- olap_open()
- olap_query()
- ones()
- open()
- or()
- output()
- p()
- pad()
- parse()
- paste()
- pca()
- pdate ()
- pearson()
- penum()
- periods()
- permut()
- pfind()
- pi()
- pivot()
- pjoin()
- pls()
- pmax()
- pmin()
- polyfit()
- pos()
- power()
- prior()
- proc()
- product()
- property()
- pseg()
- pselect()
- pseudo()
- psort()
- ptop()
- push()
- Qconnect()
- Qdirectory()
- Qenv()
- Qfile()
- Qload()
- Qlock()
- Qmove()
- query()
- r.( x )
- r.F
- r.F=x
- r2dbc_close()
- r2dbc_exec()
- r2dbc_open()
- r2dbc_query()
- rand()
- rands()
- range()
- rank()
- ranki()
- rankm()
- ranks()
- read()
- record()
- redis_close()
- redis_command()
- redis_open()
- regex()
- register()
- remainder()
- rename()
- replace()
- report_config()
- report_exportDoc()
- report_exportHtml()
- report_exportPdf()
- report_exportXls()
- report_open()
- report_run()
- reset()
- result
- return xi
- rgb()
- ridge()
- right()
- rollback()
- round()
- run()
- rvs()
- s3_ bucket ()
- s3_ close ()
- s3_ copy ()
- s3_ file ()
- s3_ list ()
- s3_ open ()
- sap_client()
- sap_close()
- sap_cursor ()
- sap_execute ()
- sap_getparam ()
- sap_table ()
- savepoint()
- sbs()
- se()
- second()
- segp()
- select()
- seq()
- sert()
- setenum()
- sf_close()
- sf_open()
- sf_query()
- sf_wsdlclose()
- sf_wsdlopen()
- sf_wsdlquery()
- sf_wsdlview()
- sg()
- shift()
- sign()
- sin()
- sinh()
- size()
- skew ()
- skip()
- sleep()
- smooth()
- sort()
- sortx()
- spark_open()
- spark_close()
- spark_cursor()
- spark_query()
- spark_read()
- spearman()
- split()
- splserver()
- sqlparse()
- sqltranslate()
- substr ()
- stax_close ()
- stax_open()
- stax_cursor()
- stax_query ()
- sqrt()
- step()
- string()
- structure
- sum()
- svm()
- swap()
- switch()
- syncfile( hs,p )
- system()
- T()
- tarcorskew()
- tan()
- tanh()
- time()
- tinv()
- to()
- top()
- total()
- transpose()
- trim()
- true
- try
- ttest_p()
- union()
- update()
- upper()
- urlencode()
- uuid()
- v()
- var()
- web_crawl()
- webhdfs()
- webhdfs_file()
- words()
- workday()
- workdays()
- write()
- ws_call()
- ws_client()
- xjoin()
- xjoinx()
- xlscell()
- xlsclose()
- xlsexport()
- xlsimport()
- xlsopen()
- xlswrite()
- xml()
- xor()
- xunion()
- year()
- ym_build_model()
- ym_close()
- ym_env()
- ym_exec()
- ym_importance()
- ym_json()
- ym_load_pcf()
- ym_model()
- ym_performance()
- ym_predict()
- ym_present()
- ym_result()
- ym_save_pcf()
- ym_setparam()
- ym_server_quit()
- ym_statistics()
- ym_target()
- zeros()
- zip()
- zip_add()
- zip_close ()
- zip_compress()
- zip_del()
- zip_encrypt()
- zip_extract()
- zip_open()
- Intersection of sequences
- Comparison operation
- Hexadecimal long integer
- Modulus
- Concatenation of sequences
- Arithmetic operations
- Compound assignment
- String
- String concatenation
- Alignment arithmetic operations
- Difference between sequences
- Union of sequences
- Multiplication of sequences
- Table sequence constant
- Record constant
- The writing rules for expression x in loop functions
- Batch Computation
- Identifier
- Opposite Number
- Empty Sequence
- Assignment
- Value Computation and Assignment
- Escape Character
- Logical Operations
- Long Integer
- Cell type
- Code block type
- Chart Elements
nvl()
Description:
Get the first non-null and non-empty-string member from a sequence.
Syntax:
|
A.nvl(x) |
|
|
nvl (x1,…,xn) |
Equivalent to A.nvl(), where x1,…,xn are members of sequence A |
Note:
The function gets the first non-null and non-empty-string member from sequence A. When parameter x is present, first compute the expression with members of sequence A and then return the eligible member.
Parameter:
|
A |
A sequence |
|
x |
An expression; cannot be omitted when A is a table sequence or a record sequence |
Return value:
A non-null and non-empty-string member
Example:
When A is a sequence:
|
|
A |
|
|
1 |
=[1,2,4].nvl() |
1 |
|
2 |
=[null,2,3,4].nvl() |
2 |
|
3 |
=[null,"",2,3,4].nvl() |
2 |
|
4 |
=nvl(null,"",2,3,4) |
2 |
When A is a table sequence or a record sequence:
|
|
A |
|
|
1 |
=create(ID,Str).record([1,"",2,,3,"aaa"]) |
|
|
2 |
=A3.nvl(Str) |
Return “aaa” |
