How to create new filed using date column in obiee

Question

Hi,

How to create new fileds in obiee using exciting columns student,email,person,date is data is available.

so how to create email wise date data column and remaining also.

could you please let me know anyone

student

person

email

date

email_date

person_date

student_date

sd

ab

ae

19-06-2022

Thanks for advance.

Renuka Nuguru-Oracle · Answer

Hi User_HQ9TE,

Creating new column with email and date is easy, which has been explained above. Can you describe your requirement in simple and clear so that we can help accordingly. Layout the base column and the data in excel, and what you are expecting in new columns.

Thanks,

Renuka

Harriet Huang-Oracle · Answer

Hi @User_HQ9TE ,

How to add those date columns depends on how you would use those columns and how the data would be populated. Would you please describe more details on the purpose to add those date columns and the data source for them?

Ram-Oracle · Answer

@User_HQ9TE -You may try the below approach.

In obiee edit formulae ,fx we see several functions.

For date column ,use cast function to convert it as CHAR.

Now pull another column and use concat function between person column and column where you had used cast function.

Please see if this approach helps.