Hi everyone, hope you are doing well.
We would like to report that we are receiving an error when we try to see the data with the option Preview visualization data, below you will find the error: Oracle 904: ORA-00904 "TableauSQL"."CDR_TRASANCTION_ID": invalid identifier
Below you will find the query that we are using:
SELECT * FROM invoice.SMS_CDR C
INNER JOIN invoice.SMS_CDR_TEXT T ON C.CDR_TRANSACTION_ID = T.CDR_TRANSACTION_ID AND T.CDR_TIME = C.CDR_TIME
WHERE C.CDR_TIME >= SYSDATE - 1 AND C.CDR_SRC_PRODUCT_ID LIKE '7931' AND C.CDR_IS_LAST LIKE '1'
Anyone could help us to understand the root cause for this error, and a possible solution for the same.
Thanks in advance for your attention
@Reporting Telintel
I think you can use something like:
SELECT
C.CDR_TRANSACTION_ID AS CTRANSID,
T.CDR_TRANSACTION_ID AS TTRANSID,
T.CDR_TIME AS TTIME,
C.CDR_TIME AS CTIME
FROM invoice.SMS_CDR C
INNER JOIN invoice.SMS_CDR_TEXT T ON C.CDR_TRANSACTION_ID = T.CDR_TRANSACTION_ID AND T.CDR_TIME = C.CDR_TIME
WHERE C.CDR_TIME >= SYSDATE - 1 AND C.CDR_SRC_PRODUCT_ID LIKE '7931' AND C.CDR_IS_LAST LIKE '1'
As I said before, probably it would be a longer query, because you will have to list all needed fields and assign different alias.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego
Tableau Ambassador
