32 920
modifications
Modifications
Sauter à la navigation
Sauter à la recherche
Ligne 58 :
Ligne 58 : + + + + + + + + + + + +
→Detect missing records
{{dbox-orange| A great way to detect missing records is to check the iteration values. }}
{{dbox-orange| A great way to detect missing records is to check the iteration values. }}
In a new column, append a formula that susbtract the previous row A column value to the current A column value.
[[Fichier:SBK-unexpected-data-60.png]]
Double-click on the small dot to repeat the formula accross all the rows.
[[Fichier:SBK-unexpected-data-61.png]]
This formula should obviously returns 1 when all the rows are available in the file.
{{SBK-TRAILER}}
{{SBK-TRAILER}}