I have a system reporting tool which will generate file. Every time I generate a report it appends any new transaction in the report.
I need help in creating a new file, based on the FILE1 generated. How will I be able to extract the Appended transaction(FILE2) every time a new file is being generated. I believe I can use the header posting_date and use the timestamp.
Any suggestion on what is the most effective way of handling this.
Do you want to extract the last row of the file and move it somehere else?
If so, use the ‘Read Range’ Activity inside and Excel Application Scope.
Get the Last row data use like this:
MyPostingDate = DT(DT.Rows.Count-1)(“Postting date”).toString
Use the ‘Apply filter activity’ to filter the data table
Inside another ‘excel application scope’ use the write range or append range to post your data.
Let us say from FILE 1 that is the original file. File 2 contains Appended information. How exactly I will use the filter data table to get only the latest transaction.
To move data from File 1 to File 2
Read the data from File 1 with a Read Range Activity inside an Excel Application Scope, it generates a data table variable
Inside another excel application scope, with file 2, use the append data table activity to past the data table in the desired variable
If it is clear for you please like my post and mark it as a solution, it helps me
Any questions please let me know
The scenario is that FILE 1 contains the Original list. File to contains the Original list and the appended data. I will like to only get the appended data from File 2. See reference file i posted.
Do you want to move data from one file to the other?
Whitch file is going to recieve the data? Which will provide the data?
I can prepare something if you want
FIle 1 is the first generated report. Now after 15min I will generate another report which is FILE 2. If you check the file 2 it contains the data from file 1 and a new record is added. I would like to get only the new record and save it to a file with the same header parameters. The reason I do this is I don’t want to create a duplicate once I upload the FILE 2 to a database system.
You want to get all the rows from file 2 that are not in file 1 and move it to another file?
Please confirm my understanding so I will prepare something for you