Continuing the discussion from Knime To Check mandatory columns for missing values from Row3 onward and flag errors if found.:
I got response for this topic. However, the solution works well for Excel files with minimal data; however, in my case, I have multiple Excel files with large data volumes. For example, the maximum case includes an Excel file with 206 columns and 2 lakhs rows. Our main goal is to reduce the time taken for transferring data from Excel to a table. Could the loop in the workflow be increasing processing time? Any other simple approach for this to reduce the processing time?
@san_98 you can try and use Python/Openpyxl to speed up the process and see if this is faster. Also the question if doing this in parallel might help.
2 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.