Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ebrambilla
Contributor III
Contributor III

Loading raw data with duplicate records, no key field

Hello, I'm new in QlikView and maybe my is a silly question...

Let' say I have the following table to import and manage

FRUITQUANTITY
APPLE1
ORANGE1
APPLE1
APPLE1
ORANGE1
APPLE1

In this situation, there is no Key field in the original data.

I would to load the table in QlikView exactly as is, and then I want to see table as is in Qlikview.

But, using a straight table, Qlikview shows only 2 records:

FRUITQUANTITY
APPLE1
ORANGE1

How is it possible to visualize the exact loaded table as shown in Table visualizer?

Any explanation is appreciated!

1 Reply
swuehl
MVP
MVP

Easiest would probably be to create a key field:

LOAD

     rowno() as RowNo,

     FRUIT,

     QUANTITIY

FROM ....;