Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am getting a field not found <TTT_NO> error when trying to runt his load script:
super:
LOAD "SSS_NO" AS [S Number],
"TTT_NO" AS [T Hours]; ----- THIS LINE
SQL SELECT
et.SSS_NO,
et.CCC_ID,
WSA_API.GSH (et.CCC_ID, et.SSS_NO, trunc(sysdate)+2) AS TTT_NO
FROM SSS_TABBLE et;
STORE super INTO $(vDetailsQVDDirectory)super.qvd (qvd);
DROP TABLE super;
Give a try on the below code and let me know the result:
super:
LOAD *;
SQL SELECT
et.SSS_NO,
et.CCC_ID,
WSA_API.GSH (et.CCC_ID, et.SSS_NO, trunc(sysdate)+2)
FROM SSS_TABBLE et;
STORE super INTO $(vDetailsQVDDirectory)super.qvd (qvd);
DROP TABLE super;
Because you are attempting the preceding load. Can I know what are you expecting from this. And please try database and then try in qlikview
SELECT
et.SSS_NO,
et.CCC_ID,
WSA_API.GSH (et.CCC_ID, et.SSS_NO, trunc(sysdate)+2) AS TTT_NO
FROM SSS_TABBLE et;
works fine in oracle sql developer
Then use same expression to get the values using alias names then trace to debug see whether the values are coming or not
I want to run the sql in the load script not in the qvd extract
Give a try on the below code and let me know the result:
super:
LOAD *;
SQL SELECT
et.SSS_NO,
et.CCC_ID,
WSA_API.GSH (et.CCC_ID, et.SSS_NO, trunc(sysdate)+2)
FROM SSS_TABBLE et;
STORE super INTO $(vDetailsQVDDirectory)super.qvd (qvd);
DROP TABLE super;
trunc(sysdate) is not valid in SQL use something like CONVERT(date,getdate()) instead
Trunc() is a valid function in Oracle unless there is a change, I used to use Oracle long years back.
The SQL is fine, its the QV part
I would rather test it like this:
super:
SQL SELECT
et.SSS_NO,
et.CCC_ID,
WSA_API.GSH (et.CCC_ID, et.SSS_NO, trunc(sysdate)+2) AS TTT_NO
FROM SSS_TABBLE et; // Correct spelling?
Now check in the Table Viewer which fields names you do get in the super table...
Peter