Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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 ....;