Data nav Join Question

Question

4.08K viewsNovember 5, 2018DataNav

0

milo 163 November 16, 2013 0 Comments

I have used data nave to connect to a oracle database. There are multiple tables I want to use.
General ledge with periodkey, versionkey, accountkey, deptkey, and companykey.
I need to join a table for each key to get a name/description. I want to create a custom fields that make the table readable. an example is as follows:
acctkey + ‘-‘ + acctdesc as account
Since acct key is in the main table and sub table I am linked to it will not accept the field. I need to do something like the following
[accountmaster].[acctkey] + ‘-‘ + [accountmaster].[acctdesc] as account
unfortunately data nave does not like this syntax. ANY SOLUTIONS?

2 Answers

score 0 · Answer 1 · 2013-12-02T13:57:48+00:00

Oracle organizes data using schemas and SQL uses databases. Data Nav can only uses join fields within the same schema/database (I Think). Crossing to another schema is my issue. Data link can do it using SQL but I haven’t found a way using data nav.

score 0 · Answer 2 · 2013-12-01T16:27:44+00:00

Hi – I don’t have an Oracle installation handy from where I am at the moment – but just curious if you found a solution? Wonder if the oracle SQL version of a Concatenate function would work?

Data nav Join Question

2 Answers

Latest Questions

Connect