Excel Importer inconsistency

0
Hello Everyone, I’m facing an inconsistency issue with data order when importing from Excel using the Excel Importer. Generally, when I retrieve the imported data, it follows the same row order as the original Excel file. However, occasionally when excel file has less than 1000 records, the data comes through in a different order, which disrupts my validation process. The challenge is that I need to validate the data based on the exact row order in the Excel file, and none of the columns can be sorted to restore this order. What makes it difficult to diagnose is that the issue occurs random. Well , It works in Local but not in Test environment. Urgent help needed thanks.   
asked
0 answers