Loading raw data with duplicate records, no key field

ebrambilla — Mon, 09 Sep 2013 15:47:50 GMT

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

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

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:

FRUIT	QUANTITY
APPLE	1
ORANGE	1

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

Any explanation is appreciated!

Re: Loading raw data with duplicate records, no key field

swuehl — Mon, 09 Sep 2013 15:50:09 GMT

Easiest would probably be to create a key field:

LOAD

rowno() as RowNo,

FRUIT,

QUANTITIY

FROM ....;