Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I'm new in QlikView and maybe my is a silly question...
Let' say I have the following table to import and manage
FRUIT | QUANTITY |
---|---|
APPLE | 1 |
ORANGE | 1 |
APPLE | 1 |
APPLE | 1 |
ORANGE | 1 |
APPLE | 1 |
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!
Easiest would probably be to create a key field:
LOAD
rowno() as RowNo,
FRUIT,
QUANTITIY
FROM ....;