Straight table tasks

[nikhilgarg]

Hi,

Whenever i add a new column in straight table , i want for newly added column:

Adjust Column width automatically

Add comma delimited.

How can i achieve this ??

Thanks

[jagan]

Hi,

Can you come up with some sample data? 

For dimension in Straight table the width of the table is automatically adjusted, for expression you will get a scroll bar, if you don't want the scroll bar then you have to adjust manually.

For comma separated values you have use Concat(DimensionName, ',') .

IF you want distinct values as comma separated then you can specify Distinct

Concat(Distinct DimensionName, ',')

Hope this helps you.

Regards,

jagan.

[nikhilgarg]

Hey,

Can you please tell me what would be the output if i use:

Concat(DimensionName, ',')

Thanks

[jagan]

Hi,

Concat() returns the values in given format, assume that you have 2012, 2013, 2014 and 2015 in Year list box, if you give

Concat(Year, ':') then you will get 2012:2013:2014:2015

Hope this helps you

Regards,

jagan.

[sibideepak]

Hi,

Can you explain about your requirement clearly , with desired o/p ??