Bypassing field while storing the value in variable

[Anonymous]

Hello Every One,

I am storing a value into a Variable, like this..

Variable = chr(39)& Concat(Distinct Date,',') &chr(39)

Now if I select any field say CustomerID, then variable value should not change.

Any idea, how I can achieve same?

Will Only() serve the purpose?

[sunny_talwar · Accepted solution]

May be this:

Variable = chr(39)& Concat({1} Distinct Date,',') &chr(39)

or

Variable = chr(39)& Concat({<CustomerID>} Distinct Date,',') &chr(39)

[Anonymous]

Above expression will return all Date from data

This works..

Variable = chr(39)& Concat({<CustomerID>} Distinct Date,',') &chr(39)