How to create new filed using date column in obiee

User_HQ9TE

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.

User_HQ9TE

Sumanth V -Oracle

@User_HQ9TE - You need to update the table using alter command to add new columns and insert data in to it.

Syntax is as below:

ALTER TABLE table_name
  ADD column_name column_definition;

Wayne Van Sluys11111

What date will be in the Email_Date, Person_Date and Student_Date?

Ram-Oracle

@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.

Harriet Huang-Oracle

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?

Renuka Nuguru-Oracle

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