topic Re: how to find out Primary Key in Oracle View in QlikView

how to find out Primary Key in Oracle View

joshibabu_are — Wed, 01 Mar 2017 07:12:38 GMT

Hi guru's,

i have one view which is from Oracle eBS.i ran the query in sql developer and exported to excel .

and loaded in Qlikview application to find out Primary key or Composite key using Show frequency Option.

but iam unable to find the Key.

How to achieve this.

any help would be greatly appreciated.

please find Qlik application.

Thanks,

Joshi

sasikanth — Wed, 01 Mar 2017 07:31:09 GMT

HI joshi,

Go to Table viewer and mouse over on table then it will show you no. of fields and no.. of keys

also if you mouse over on a field , if it is a key field then you can see tag as $key.

please find the below image for clarity

joshibabu_are — Wed, 01 Mar 2017 07:36:46 GMT

hi sasi thanks for your Time.

if it is joined with another table then only it will show whether its perfect key or not as per my knowledge.

but here i have only one table .

Thanks,

Joshi

sasikanth — Wed, 01 Mar 2017 07:40:37 GMT

Yes,

If it is single table just hover the mouse on field name.

you will find a tag "$key" it doesn't mean that a key field.