topic Re: Problem with duplicate fields in select when retrieved in QlikView

Problem with duplicate fields in select when retrieved

Fri, 07 Nov 2014 14:48:15 GMT

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.

Re: Problem with duplicate fields in select when retrieved

avinashelite — Fri, 07 Nov 2014 16:28:03 GMT

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.

Re: Problem with duplicate fields in select when retrieved

Anonymous — Fri, 07 Nov 2014 16:39:33 GMT

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.

Re: Problem with duplicate fields in select when retrieved

Fri, 07 Nov 2014 16:43:42 GMT

Could you post a sample if possible?

Re: Problem with duplicate fields in select when retrieved

Mon, 10 Nov 2014 12:05:29 GMT

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.

Re: Problem with duplicate fields in select when retrieved

jagan — Mon, 10 Nov 2014 12:35:38 GMT

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