View calculated field gives error: ORA-00904 invalid identifier
Answered
I´m trying to add a calculated field adding number of days to a daytime field.
I opened the calculated field editor and selected freehand SQL
I used the syntax "table name"."daytime" + "table name"."days"
I tried using the view aliases and database table name. When validating I get ORA-00904 invalid identifier.
When I create a virtual table and using sql:
SELECT
"T1"."OBJECT_ID",
"T1"."DAYTIME",
"T1"."REMAINING_RATE_INSTANT",
"T1"."DAYTIME" + "T1"."REMAINING_RATE_INSTANT" AS ADD_DAYTIME
FROM "ANALYTICS"."DV_XCH_TANK_STATUS_HISTORY" "T1"
"T1"."DAYTIME" + "T1"."REMAINING_RATE_INSTANT"
This calculates the new date. Is there anything I am missing with the calculate field editor?
Thanks
Actually I found the solution elsewhere in the forum. It was solved by (1) setting the table as mandatory and (2) using the name as found in the oracle db and using the table alias in the yf view....
Actually I found the solution elsewhere in the forum. It was solved by (1) setting the table as mandatory and (2) using the name as found in the oracle db and using the table alias in the yf view....
Hi John,
Thank you for reaching out with this and for updating us on your progress and success in finding a solution.
Please let me know if you need any information regarding freehand SQL calculated fields or have any further questions.
Thanks,
Jared
Hi John,
Thank you for reaching out with this and for updating us on your progress and success in finding a solution.
Please let me know if you need any information regarding freehand SQL calculated fields or have any further questions.
Thanks,
Jared
Replies have been locked on this page!