Expression Work

[jdunkerley]

A number of functions for expressions return errors. The following return an error of Method rename of type Text (or Integer)could not be found.

• [x] at
• [x] get
• [ ] first
• [x] last
• [x] name
• [x] length
• [ ] count
• [x] count_nothing

The following return an error of Expression.Syntax_Error: extraneous input 'between' expecting {'(', '#', '-', NULL, NOTHING, TRUE, FALSE, IF, UNARY_NOT, IDENTIFIER, EXCEL_STRING, PYTHON_STRING, NUMBER, COLUMN_NAME} (line 1, column 0).

• between([OrderCount],1,3)
• like([TERRITORY],'N%')

And one returns a warning that it has been deprecated

• Warning: Deprecated: auto_value_type has been replaced by auto_cast.

Incorrect output on one function (I believe)

• duplicate_count - I have only 10 rows of data, but it returns a duplicate_count of 12 on a column.

Workflow attached here: https://drive.google.com/file/d/1ObpAAqury2BJv8JSid2IFhQVLxHPR00y/view?usp=drive_link

To Add:

• now (timestamp)
• today (date)

[steve-enso]

I am not certain that auto_cast does anything. I would have expected this to cast the char numbers to a float.

[jdunkerley]

Scalar functions all working now.

In Expressions:

• between has to be written <a> BETWEEN <B> AND <C>

• like has to be written <a> LIKE <expr>

• duplicate_count working fine (had incorrect expression in component)