Filter distinct rows

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

I'm using the following load statement with distinct. It seems to work because when I create a table with all the fields, and copy values to excel, I only get 2491 rows. But when I go to the table Viewer in QlikView, it shows that I have 88270 rows!

Where are the other rows? How can I "clear/delete" them? As if they exist, they are duplicated.

LOAD DISTINCT

ccos_codigo,

ccos_nombre,

ppit_codigo,

ppit_nombre,

tpcc_codigo,

tpcc_nombre,

itcc_coddep,

code_nombre,

ctne_codigo,

ctne_nombre,

coge_codigo,

coge_nombre,

itcc_coduni,

Unidad,

if(IsNull(espe_codigo),-1,espe_codigo) AS espe_codigo,

if(IsNull(espe_nombre),'S/E',espe_nombre) AS espe_nombre,

aipp_codigo,

aipp_nombre,

mone_codigo,

mone_abrevi

FROM

[Matriz.qvd]

(qvd)

Re: Filter distinct rows

vinieme12 — Thu, 29 Dec 2016 20:14:47 GMT

if you are creating a tablebox then you will only see distinct values in each field as tablebox is only a collection of listboxes and not exactly your table data.

Search and Read other threads for Distinct load in community

Distinct (Load)

After your table load add a statement to store the table in excel if you want to see the data that was loaded as it is.

TABLENAME: