Skip to content

Latest commit

 

History

History
549 lines (536 loc) · 16.1 KB

functions.md

File metadata and controls

549 lines (536 loc) · 16.1 KB

DataSae Column's Function Based on Data Type

Boolean

Function Name Parameter Description
Name Type
is_bool column String is boolean
is_in is_in List is in
column String

String

Function Name Parameter Description
Name Type
contain str_contain String contain
column String
not_contain str_not_contain String not contain
column String
regex_contain regex_data String regex contain
column String
special_char_contain char String special character contain
column String
is_uppercase column String is uppercase
is_lowecase column String is lowercase
is_capitalize_first_word column String is capitalize first word
is_capitalize_all_word column String is capitalize all word
exact str_exact String exact match
column String
is_in_contain str_is_in_contain List contain to multiple
column String
is_in_exact str_is_in_exact List exact match to multiple
column String

Timestamp

Function Name Parameter Description
Name Type
equal_to value Datetime equal
column String
less_than value Datetime less than
column String
less_than_equal value Datetime less than equal
column String
greater_than value Datetime greater than
column String
greater_than_equal value Datetime greater than equal
column String
in_range lower_limit Datetime in range
upper_limit Datetime
column String
is_in value List is in
column String
not_in value List not in
column String

Float

Function Name Parameter Description
Name Type
equal_to value Float equal
column String
less_than value Float less than
column String
less_than_equal value Float less than equal
column String
greater_than value Float greater than
column String
greater_than_equal value Float greater than equal
column String
in_range lower_limit Float in range
upper_limit Float
column String
is_in value List is in
column String
not_in value List not in
column String

Integer

Function Name Parameter Description
Name Type
equal_to value Integer equal
column String
less_than value Integer less than
column String
less_than_equal value Integer less than equal
column String
greater_than value Integer greater than
column String
greater_than_equal value Integer greater than equal
column String
in_range lower_limit Integer in range
upper_limit Integer
column String
is_in value List is in
column String
not_in value List not in
column String
length value integer length
column String