How do we iterate through multiple file in input folder in RE Framework?
Scenario:
INIT state: I am Reading the Outlook mails which has .csv attachments and Storing into an Input folder as below:
I need to iterate to each file and process each Item in SAP Application and Add status column and Update the Status for each item based on Business rule and save the file into Output folder with Status per transaction processed.(this Process should be repeating for all file in the Input folder and move the file to the Processed folder once items are processed.
I mean to say is In Each excel file there are multiple rows for each row i need to do a transaction. and once the Transaction is complete for one excel file and updated the status. then It should take the next excel file and process the Transaction
It should process all the Items in Excel file and Create a new column next to Quantity and Update the Status as Success.
same way next it should pick the Next file and perform the Transaction for each item.
when i run my worflow the status is not updating for MaterialCode Duplicate.
The Query you have Provided is for First Index:
There can be duplicate material code also in the Data sheet. I need to Post for all the data including Duplicates.
dtbRecords.AsEnumerable().Select(Function(r, i) New With {.Row = r, .Index = i}).Where(Function(x) x.Row.Field(Of Double)(“MaterialCode”) = Convert.ToDouble(in_MaterialsNo)).First.Index
Can you modify the query?
Status should be updated for Duplicate Records also in the next Transaction.
Check this updated framework, it will move the processed file to a processed file directory. Also update the status based on the transaction item index.
You have to change the Status Text in SetTransactionStatus.xaml for status variable as you want. ProcessCSVFiles.zip (2.5 MB)