Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
vengadeshpalani
Creator
Creator

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
sunny_talwar

Try with DISTINCT

BridgeTable:

IntervalMatch (Date)

Load DISTINCT FromDate,

ToDate

resident TempFact;

View solution in original post

3 Replies
swuehl
MVP
MVP

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

IntervalMatch (Extended Syntax) ‒ QlikView

sunny_talwar

Try with DISTINCT

BridgeTable:

IntervalMatch (Date)

Load DISTINCT FromDate,

ToDate

resident TempFact;

willbleksem
Contributor III
Contributor III

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.