what are the types can be assigned to constant in the manifest file?

Hi,

I saw on the documentation that there is an option to assign constant values to variable with “constant”.

In the documentation only a string was inserted as a value.

can I use the same method to assign other types of variables? like number (of mathematical operations) or lists to it?

for example: 

I want to check if a given name is a friend of someone in my list.

constant: my_list {

value: “Oren”, “Dan”, “Nicole”

}

and than use it like this:

dimension : name {

type: string

SQL: ${TABLE}.name

}

dimension: friends {

type: yesno

SQL: case when ${name} in @my_list then yes end;;

}

2 0 454
0 REPLIES 0
Top Labels in this Space
Top Solution Authors