Forum Discussion
Anonymous
7 years agoNot applicable
Passing variables inside DATATABLE()
Hello,
Is there a way to pass variables inside DATATABLE() ? Documentation says it's not but I still would like to see if someone came up with hack to do that.
here is the example. I would like to pass varaibles One, Two, Three as a second value in a row constructor inside DATATABLE( )
DEFINE
VAR Three = 3
VAR Two = 2
VAR One = 1
VAR cars = DATATABLE(
"Maker", STRING, "Sales", INTEGER, {
{ "Ford", 3 }, // I would like to pass variables from above { "Ford", Three }
{ "Jaguar", 2},
{ "Jaguar", 1 }
})
EVALUATE
FILTER(
cars,
[Sales] >= 2
)Thanks
Anonymous
An alternative could be
Table = VAR Three = 3 VAR Two = 2 VAR One = 1 VAR cars = { ("Ford", Three), ("Jaguar", 2),("Jaguar", 1 )} RETURN FILTER(cars,[Value2] >= 2)
1 Reply
- Zubair_MuhammadCommunity Champion
Anonymous
An alternative could be
Table = VAR Three = 3 VAR Two = 2 VAR One = 1 VAR cars = { ("Ford", Three), ("Jaguar", 2),("Jaguar", 1 )} RETURN FILTER(cars,[Value2] >= 2)