Dynamic Need Repeat Value

[muniyandi]

Hi,

i have one input box. user will enter the value . that time i need calculate.

Column() is slandered value.

Ex: User entered value is 5

I expected result  is : Column(1)&Column(2)&Column(3)&Column(4)&Column(5)

i am using Straight chart. i need some expression.

[#2]

You can try writing expressions for the columns based on your need. Using a conditional enable, you can hide and show the required Columns. But in this case number of expressions will be equal to number of columns you wish to concatenate.

[muniyandi]

now i handled in if condition .it's very huge.  now i want to avoid the if condition .

[tresesco]

Like:

=$(=Pick(vColInput,'Column(1)','Column(1)&Column(2)','Column(1)&Column(2)&Column(3)','Column(1)&Column(2)&Column(3)&Column(4)','Column(1)&Column(2)&Column(3)&Column(4)&Column(5)'))

may be a simpler solution would be possible, but not yet struck.

[#5]

Either you have to use If or you have to conditional enable multiple expressions. PFA the example. Hope it helps you.

[muniyandi]

Hi Tresesco & Deepak ,

Thanks for reply.

=$(=Pick(vColInput,'Column(1)','Column(1)&Column(2)','Column(1)&Column(2)&Column(3)','Column(1)&Column(2)&Column(3)&Column(4)','Column(1)&Column(2)&Column(3)&Column(4)&Column(5)'))

this expression also we are hard code the values,

i m expecting :

for loop method / Valueloop.

[PradeepReddy]

Probably you can achieve this using Macros...