How can I index multiple values of a constant

Question

Hi, 
 I have a constant which contains array of text, I want to check if a given value is in the array subset of that constant. 
 For that I'm using- 
 contains( 
 { 
 cons!TA_CITY_LABEL[1], 
 cons!TA_CITY_LABEL[3], 
 cons!TA_CITY_LABEL[4], 
 cons!TA_CITY_LABEL[7] 
 . 
 . 
 . 
 and many more 
 }, 
 local!label 
 ) 
 I wonder if there is any solution to it as I have to write the name of constant again and again and I'm checking this multiple times on different datasets.

Sanchit Gupta (Xebia) · Accepted Answer

You can use it like cons!name[array of indices] , this will save you much time. 
 contains(
 cons!TA_CITY_LABEL[{ 1, 3, 4, 7 }],
 local!label
)

Harshit Bumb (Appyzie) · Answer

index( cons!TA_CITY_LABEL,{1,2,3,4},{} )

How can I index multiple values of a constant

Top Replies