topic Re: Extrange result on Resident Load ordered by in QlikView

Extrange result on Resident Load ordered by

marcosadlercreutz — Sat, 16 Nov 2024 05:10:42 GMT

Dear all, i´ll go right into a extrange thing it´s hapenning.

A simple load it´s giving me a headache...

Script:

// First Load

Recursos_tmp:
Load *
FROM [lib://Datos/AMB Maestros\ABM Recursos Humanos*.xls*]
(ooxml, embedded labels, header is 1 lines, table is [ABM Personal]);

// Second load

Recursos_tmp1:
NoConcatenate
Load * Resident Recursos_tmp order by DNI asc, "Fecha Desde" desc;
drop table Recursos_tmp;

This script returns null values on field called "DNI"... When i try the same thing without "order by..." the DNI part returns true values...

Any help?

After "First Load"

After Second Load

Thanks in advance!

Re: Extrange result on Resident Load ordered by

marcus_sommer — Wed, 21 Nov 2018 12:41:28 GMT

Are you sure that you compares the same records?

- Marcus

Re: Extrange result on Resident Load ordered by

marcosadlercreutz — Wed, 21 Nov 2018 13:47:27 GMT

@marcus_sommer Thanks for your reply

I think i do...

I have changed my script to this:

Recursos_tmp1:
NoConcatenate
// load date(if(Previous(DNI)=DNI,Previous("Fecha Desde")-1,today())) as Hasta, *;
Load * Resident Recursos_tmp where not IsNull(DNI) order by DNI asc, "Fecha Desde" desc;
drop table Recursos_tmp;

That gives my a correct content of "DNI" field.

I think the fact of having some null values in that field kind of "break" things...

Best regards