Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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

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.