want to remove data from excel which are processed ,
i am having one output file as attached so after reprocessing not okay customers they will become ok, so how to remove those rows of customers from excel which are got okay.
@amruta_pawar Are you able to Update Not Okay Customers to Okay ? Are you Performing that already ? If you are already performing it, then You just need to find the rows which have Ok in it, then Delete them using Invoke Method Inside a For Each Loop.
yes after some correction in data we have to reprocess not okay then statement status column will become okay , so how i can find the same customers which are now having status as okay?
As all other fields will be same till status column.
After the After the Status Column is Updated, You can use the Workbook Read Range Activity to read the File.
Then use this linq Query to get the Data Rows of the Columns Which are “Okay” in this way :
dataRowArray = DT.AsEnumerable.Where(Function(x)x(“Statement Status”).ToString.Trim.ToLower.Equals(“okay”)).ToArray
Where dataRowArray is of the type Array of DataRow
Next, In a For Each Loop for dataRowArray, Change Type Argument to DataRow
Inside For Each Row, Use Invoke Method Activity, where Target Object is the Datatable and Method Name is Remove, with parameters as item Change the Type to Data Row.
The Resulting Datatable will be having the Removed Rows, You can Write this Datatable to the Output File using Write range Activity.
@amruta_pawar Getting a Bit Confused here
Can you explain what you are trying to Do in Steps or using Screesnhots, maybe in that case I’ll have a Better Understnading
ok please find attched excel file for reference , i am having output file after processing i need expected output file.Expected_Output file.xlsx (9.2 KB)
@amruta_pawar Check the Workflow :
Delete the Output Sheet in Excel File, Run the Workflow, Check the Excel File, It Should be the Output you needed. RemoveProcessedDuplicates.zip (9.8 KB)
ohh wow thank you so much for your efforts and time, just one more request how i can add more columns into group by as i want to add company code,frequency,start date,end date to our linq.