Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
vengadeshpalani
Contributor

Why records duplicated

Hi all

by using of autonumber function i map two fields, original record is near to 320000 when i store in to qvd it duplicated (it has 4.5GB)

66.png

I added row no for the show the duplication

i attached sample PFA

1 Solution

Accepted Solutions

Re: Why records duplicated

Try with DISTINCT

BridgeTable:

IntervalMatch (Date)

Load DISTINCT FromDate,

ToDate

resident TempFact;

View solution in original post

3 Replies
MVP
MVP

Re: Why records duplicated

You are probably missing an additional key field with IntervalMatch(), maybe constructed using JobNo and DateFinalStatus:

IntervalMatch (Extended Syntax) ‒ QlikView

Re: Why records duplicated

Try with DISTINCT

BridgeTable:

IntervalMatch (Date)

Load DISTINCT FromDate,

ToDate

resident TempFact;

View solution in original post

Highlighted
willbleksem
New Contributor III

Re: Why records duplicated

Your Tempfact Join is not necessary.in line 20. This creates a table within a table. Like a forced join. and an Interval ID which you mentioned in the TempFact table in the beginning already.