July 17, 2007, 08:44 PM
ViralJoin issue, getting incorrect data
Hello,
I am creating the report where holding the data into three hold files (data is coming from the single source), and when join all them using single field.
Getting two of the hold files data correct but the one hold file always data repetative.
Dataset look like
Hold1
F1 F2 F3 ( Fields)
A B C
A D E
Hold2
F1 F2 F3 ( Fields)
A 11 12
A 21 22
Hold3
F1 F2 F3 ( Fields)
A A1 A2
A B1 B2
Now when join them using field F1 which have same value "A".
Data comes like
A B C A1 A2 l1 12
A D E B1 B2 11 12
See here 11 12 repetative, any idea will great help.
Thanks in advance for your suggestion.
WF 7.1.6/ OS - WIN2003.
July 18, 2007, 03:29 AM
Tony AViral,
Read up on cartesian sets.
T
July 18, 2007, 09:19 AM
LeahAs Tony hints at, your join structure can cause a multiplicative affect. As you don't post your join, are you doing what I call a horizontal join, or a vertical join?
Horizontal
JOIN F1 IN HOLD1 TO F1 IN HOLD2 AS J1
JOIN F1 IN HOLD1 TO F1 IN HOLD3 AS J2
Vertical
JOIN F1 IN HOLD1 TO F1 IN HOLD2 AS J1
JOIN HOLD2.F1 IN HOLD1 TO F1 IN HOLD3 AS J2
Which you affects how data is viewed/reported.
July 20, 2007, 06:27 PM
ViralThanks Leah!
I tried the vertical option also but didn't worked. Anyway now doing most of the part in the database and it fixed the issue.
Thanks