Straight Table is removing Repeated Entries

[Anonymous]

I am importing the below data to QlikView from Excel file.

Column A	Column B
A	APPLE
A	APPLE
A	APPLE
B	DATES
C	GRAPES
D	Greece
E	MANGO
F	MELON
G	POME
H	ROME

When I create a straight table object QlikView is removing the repeated entries by collating it as a 1 entry and the result is below. Why QlikView is doing this? Is there a way to create a straight table without collating the repeated entry...(A APPLE)???

Column A	Column B
A	APPLE
B	DATES
C	GRAPES
D	Greece
E	MANGO
F	MELON
G	POME
H	ROME

[jpenuliar]

Had a similar situation before;

Table box Rows does not match Charts/expressions/statistics aggregates

[jpenuliar]

you can add a RecNo() in your Load script

e.g.

Load

RecNo,

[Column A],

[Column B]

...

[awhitfield]

Qlikview will interpret the 3 Apples as three of the same item, if you added the expression (Count(ColumnA), yu would see this. See the example attached

Andy

[jpenuliar]

Hey Bats!

[awhitfield]

We strike again!

[jpenuliar]

This Community more fun with 2 Bats

[vvvvvvizard · Accepted solution]

ctr+e , insert

after the load

rowno() as row_num,

field a , ....

[Anonymous]

Thanks Yusuf. It worked.

Thanks everyone for the timely help.

[Anonymous]

Guys need a help. I tried inserting RowNo() after Load statement and it worked great. But this time I am not having Load statement.. I am using SELECT directly... How should I include RowNo() now???