Problem with duplicate fields in select when retrieved

[#1]

Hi, Im new to Qlikview and am having a problem developing my app.

The data I am trying to select is from a Database, and is a view. I have used other views and they select correctly.

When I try to select from this view, duplicate entries appear in it that are not in the base view.

it duplicates a couple of the fields - not all of them.

its not a DB connection issue as I can select the correct info from the view into excel.

I have dropped and re-created the view to ensure there is no problme with it.

has anyone any ideas what is wrong?

Im using version 11.20.12129.0 SR4

thanks

ALex.

[avinashelite]

Hi Alex,

Its not the issue with DB, its the issue in your data model what you have created.

Please attach you app with sample data, will fix the issue.

[Anonymous]

Hey,

Try to write the required columns from view select statement and check if duplication of these fields are happening or not.

Ensure that your view is not having the duplicate column names. or these 2 fields are not exist in other views that you are pulling into same qv app. If exist you may need to rename if required according to the fitment for your requirement.

Regards,

Chinna.

[#4]

Could you post a sample if possible?

[#5]

Thanks for the replies.

There is NO other view in the app.

I am creating a new app for this view and it duplicates some - not all of the fieldnames.

the view is defined :-

create view  qlik_vw_invoice as

select invoice_number = i.invoice_no ,  

invoice_type = isc.invoice_st_desc,

i.invoice_date ,

i.custcode ,       

invoice_currency = i.currency ,

i.inv_addr1 ,

i.inv_addr2 ,             

i.inv_addr3 ,

i.inv_addr4 ,

i.inv_addr5 ,

i.invoice_business_unit

from   s2_invoice_log i, inv_status_cds isc

where i.invoice_status = isc.invoice_status

and i.invoice_date >= '03.05.2010'

when I load this in Qlikview I get:-

as you can see, in the pane on the right, some of the fields have been duplicated.

Alex.                                                          

[jagan]

Hi,

Instead selecting the columns from Qlikview, query it in database and pull the required columns like below and use it in Qlikview

SELECT

Field1,

Field2,

'

'

'

FROM TableName;

Regards,

Jagan