Column names

Solved!
GSung
Level 3
Column names

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?

 

0 Kudos
1 Solution
EliasH
Dataiker

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

View solution in original post

2 Replies
EliasH
Dataiker

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
Level 3
Author

it works! thank you!