Last updated: Jan 17, 2024
You can type CLEM expressions manually or use the Expression Builder, which displays a complete list of CLEM functions and operators as well as data fields from the current flow, allowing you to quickly build expressions without memorizing the exact names of fields or functions.
In addition, the Expression Builder controls automatically add the proper quotes for fields and values, making it easier to create syntactically correct expressions.
Notes:
- The Expression Builder isn't supported in scripting or parameter settings.
- If you want to change your datasource, before changing the source you should check that the Expression Builder can still support the functions you have selected. Because not all databases support all functions, you may encounter an error if you run against a new datasource.