Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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_Muhammad's avatar
    Zubair_Muhammad
    Community 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)