How do i call Oracle Hyperlink statement into Qlikview report table

[saivina2920]

I have below fields in oracle.

'http://emy.amoia.org/webtop/Mmols/objId/' || emp.emp_id ||'/ver/New' as HyperlinkDoc

how do i call the above fields in LOAD statement followed by select statement.

[Nicole-Smith]

Table:
LOAD 'http://emy.amoia.org/webtop/Mmols/objId/' & emp_id & '/ver/New' as HyperlinkDoc;
SELECT (all of your fields, make sure you include emp.emp_id)
FROM YourTable;

Note: If you rename emp_id in the SELECT statement, you will need to put whatever you renamed it to in the LOAD statement.