Posted Fri, 26 Nov 2021 23:23:01 GMT by Joe Wolner Programmer / Analyst
We've written an automate to do a pretty simple "Loop through the contents of file", put the contents into a variable and then write to a different file contents using Mid() and a custom date function.  We're looping a 9mb file but it takes 4.5 HOURS for this thing to run.  Attached is a screen shot of most of the task.  I am wondering if there would be a more efficient way to perform this?  The reason for the Mid() is that the input file is fixed length fields that I want to write to a "not symbol" delimited file.  The special function converts a 7 digit date to an SQL Friendly one.  We then bulk load a database table with the new file.
Posted Thu, 30 Jun 2022 13:40:28 GMT by Amy Knode
Hi Joe,

Please open a case with the Automate support group for this so we can take a closer look at your task and environment.



You must be signed in to post in this forum.