Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
oseimuduame
Contributor

Duplicate Data

Good Morning,

I have a small challenge here, i am fetching data from an Oracle Database into Qlikview but then i discovered that the data i am getting is twice what i have in my Oracle Database.

Please any help please as this just scattered my whole report.

Await a speedy response.

Thank You in advance

22 Replies
felipedl
Valued Contributor III

Re: Duplicate Data

Hi Omotayo,

Are you doing some sort of concatenate or join statement when retrivieng the data?

That might be causing the double entry data you see.

oseimuduame
Contributor

Re: Duplicate Data

Hi Felip,

I have some few LEFT JOIN, RIGHT JOIN and INNER JOIN, this was due to JOINING table together to get accurate DATA.

What do you suggest i can do to correct this?

felipedl
Valued Contributor III

Re: Duplicate Data

You'll have to see which combinations of data (left and right joins) are giving you the duplicated data.

What kind of combinations gives more than one line for your data that these joins are dupplicating the data.

It's more an investigative data search than something we can actually help without some sample data or QVW to work on.

Can you share some screenshots or app with example data?

oseimuduame
Contributor

Re: Duplicate Data

Attached is the Two Scripts i am sure i am Joining the or concatenating.

OH_QTY is the major one i had issues with right now. I joined my Inventory Table and Qty Table together which is causing the issues

Hope this helps

invn qty.PNGinvn.PNG

felipedl
Valued Contributor III

Re: Duplicate Data

I'm assuming by the join in the sql statement that both the tables have more than one entry for each ITEM_SID.

Something like:

INVN_SBS table:

ITEM_SID, COST,MATERIAL

1,1,1

1,3,2

2,10

3,50

and the INVN_SBS_QTY might look something like this:

ITEM_SID,SBS_NO,STORE_NO,QTY

1,1,1,100

1,2,1,200

2,1,1,13

2,1,2,15

3,3,3,50

Which gives duplicate rows as below:

Sample.png

Since you're only joining by the ITEM_SID the combination of ITEM_SID on the INVN_SBS with the join by INVN_SBS_QTY  table can generate such cases.

One option is to identify if adding another field (in my assumption case, the MATERIAL field) that differentiates the rows of both tables.


Can you share some rows as to how your data is duplicating and some related table data?

oseimuduame
Contributor

Re: Duplicate Data

Attached is the Screenshot of the Data... This Item is suppose to have 1qty not two two as in this case.

dash.PNG

felipedl
Valued Contributor III

Re: Duplicate Data

It's definately a duplication issue.


Can you put all the fields of the original tables and take a screenshot or paste it into an Excel spreadsheet after the join?

oseimuduame
Contributor

Re: Duplicate Data

checkDah.PNG

Attached is the Table Showing the Query... the field for OH_QTY carries duplicate quantity. All the figures here are not correct.

felipedl
Valued Contributor III

Re: Duplicate Data

It would be necessary to get all field for both tables, INVN_SBS and INVN_SBS_QTY.


Can you get all fields from both tables for the first ITEM_SID that appears on your screenshot please?

Community Browser