Different data formats in one column

[gauravp1993]

Hello everyone,

I was trying to convert one of our fact column, which contain two type of data (as per their meaning from dimension) into two format - one will contain commaw. format and other contain numw.d format. Is it possible to convert and store both of them in single column?

We have to send this data to VA report and display over there.

Thank you in advance!

[Astounding]

Speaking in generalities ...

You would need to define your "single column" as character, and convert the incoming values to character (using different formats depending on the dimension).

[SASKiwi]

Since you are loading this data into VA I would create a calculated measure in VA based on the original variable to get the second required format.