Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Straight Table is removing Repeated Entries

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

 

Column AColumn B
AAPPLE
AAPPLE
AAPPLE
BDATES
CGRAPES
DGreece
EMANGO
FMELON
GPOME
HROME

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 AColumn B
AAPPLE
BDATES
CGRAPES
DGreece
EMANGO
FMELON
GPOME
HROME
1 Solution

Accepted Solutions
vvvvvvizard
Partner - Specialist
Partner - Specialist

ctr+e , insert

after the load

rowno() as row_num,

field a , ....

View solution in original post

9 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

jpenuliar
Partner - Specialist III
Partner - Specialist III

you can add a RecNo() in your Load script

e.g.

Load

RecNo,

[Column A],

[Column B]

...

awhitfield
Partner - Champion
Partner - Champion

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
Partner - Specialist III
Partner - Specialist III

Hey Bats!

awhitfield
Partner - Champion
Partner - Champion

We strike again!

jpenuliar
Partner - Specialist III
Partner - Specialist III

This Community more fun with 2 Bats

vvvvvvizard
Partner - Specialist
Partner - Specialist

ctr+e , insert

after the load

rowno() as row_num,

field a , ....

Anonymous
Not applicable
Author

Thanks Yusuf. It worked.

Thanks everyone for the timely help.

Anonymous
Not applicable
Author

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???