Split the input box

[khadeer]

I have dimension called model that has following value

ax

ay

az

ad

as

bx

by

bz

i have put this above value in input box by using expression =concat(distinct model ,',')

but now i have to show two input boxes containing ax,ay,az and other input box should contain bx,by,bz.(on the basis of above condition i.e concat(distinct model ,','))

[MayilVahanan]

Hi,

     Try this,

     = Concat({<model = {'ax','ay','az'} >} distinct model,',')

     Same like  Concat({<model = {'bx','by','bz'} >} distinct model,',')

     or if you want all values start from 'a' means

  = Concat({<model = {"a*"} >} distinct model,',')

     for b, Concat({<model = {"b*"} >} distinct model,',')

Hope it helps