Remove duplicate columns

InduPriya

Hi,

I have converted the timestamp value [In BIRT while querying for the data] present in my oracle database to a readable format using one of the stored procedures.This timestamps have milliseconds values also in it, but while converting them to readable format the milliseconds are ignored so duplicate values are obtained in the preview results. Even I used distinct function but still no luck as Iam converting the timestamp in BIRT and assigning the value to a different column name. So can someone please suggest me on how to remove duplicates using the computed columns.

Thanks in Advance,
Indu.

mwilliams

Hi Indu,

Can you describe in more detail, maybe show some screenshots or even re-create this issue using the sample database? Thanks!