Excel to CsPro producing wrong IDs
Posted: March 15th, 2019, 1:20 pm
Sometime ago I had posted an issue that my ID (sector) had 15 positions, and when creating the csdb the ID, someties, was changed to a number "close" to the original.
The answer was that the value was being handled by a floating point routine.
Because of that I split my ID in five parts, UF, MUNIC, DISTRICT, SUBDISTRICT and SECTOR, believing that this would solve my problem.
But it did not, it still change the IDs, and maybe because of that, it generates less cases than the original file.
See the enclosed files. The second case 110002305000045 is generated as 110002305000044, the 14th 110012205000081 is generated as 110012205000080, etc, and the final file has 1492 cases instead of the original 1500.
Best
Ari
The answer was that the value was being handled by a floating point routine.
Because of that I split my ID in five parts, UF, MUNIC, DISTRICT, SUBDISTRICT and SECTOR, believing that this would solve my problem.
But it did not, it still change the IDs, and maybe because of that, it generates less cases than the original file.
See the enclosed files. The second case 110002305000045 is generated as 110002305000044, the 14th 110012205000081 is generated as 110012205000080, etc, and the final file has 1492 cases instead of the original 1500.
Best
Ari