Hola Marcos. Try this.
SUB CalcularFaltantes
Autorizacao: //change this for your table name
LOAD my_number //change this for your field name
<Here the LOAD of your text file>
;
Temp:
Load
Min(my_number) as MyMinNumber,
Max(my_number) as MyMaxNumber
Resident Autorizacao
;
//Let vMyMinNumber = Peek('MyMinNumber', 0, 'Temp') ;
//Let vMyMaxNumber = Peek('MyMaxNumber', 0, 'Temp') ;
Faltantes:
Load
MyMinNumber + IterNo() - 1 AS [MyNumber],
Resident Temp
While MyMinNumber + IterNo() - 1 <= MyMaxNumber
;
DROP Table Temp;
Left Join(Faltantes)
LOAD
[my_number] AS [MyNumber],
[my_number] AS [This one exists]
Resident Autorizacao
;
END Sub
You can made a chart table. When the field [This one exists] is empty, means that there is a lack. Hope this help, I didn't test it.
Regards.
Damian.
