Why to define Joins if Same column names are available in two table?
I have two tables A and B. A have 15 records and B have 6 records. when I am loading the table in qlikview, tables are automatically getting joined as 1 column is same in both the table, but when i am counting no of records its showing me 15 only. when I am joining the table by writing Join in script in qlikview then its showing me 90 records. I checked in database, there also its showing 90 records. So why if table is getting join without mentioning joins in script it is not showing correct count?
I'm going to guess that Table A and Table B have 1 distinct value for the common field. When you load without joining in the script you'll have 15 and 6 records in Tables A & B respectively. The tables will be associated on the common field and if there is only one distinct value in this field each record in A will be associated with every record in B. When you join in the script you'll get one table with 15 x 6 = 90 records.