Column names

GSung

Is it a known issue whereby I cannot apply formulas to columns that have a space or number as part of the name?

For example, I have two columns QQ 1 and QQ 2

I cannot seem to use the formula QQ 1 - QQ 2, and I needed to rename the columns to QQ 1 to QQ_one & QQ 2 to QQ_two.

What is the reason behind this?

EliasH

Hi,

you can use

val("column with spaces")

to retrieve the values in your column!

Refer to this doc for more information:
https://doc.dataiku.com/dss/latest/formula/index.html#reading-column-values

GSung

it works! thank you!