Instead of building excessive loops, which are extremely inefficient, use Find or replace in data table to find if a value in your target file (BD) exists in the value of the origin file (SL).
So, build a single loop to iterate through the rows in the SL line. And then for each row, use Find or replace in data table to find if the BD file contains the current value from the SL line. This action will return a variable called %DataTableMatches% which is a data table with row and column indexes of the matched rows. If this BD file does not contain the value, this table will be empty. So, you can use an If condition to check if %DataTableMatches.RowsCount% equals to 0. If it does, you can use Next loop to skip to the next iteration.
If the matches is not empty, you can then use the row index to delete the row from your Excel file. Now, depending on whether or not you may have more than one match, you may either need to:
a) build a loop through the matches table to handle each match (if there can be more than one)
b) simply pick up the first match (if there cannot be more than one).
And then you need a Convert text to number action to convert the index to a numeric value. Get it as %DataTableMatches[0]['Row']% and convert it to a new variable - for example, %RowIndex%. Then use this in the Delete row from Excel action. But make sure you increment it by 2, because indexes are 0-based and ignore the header row in Excel. So, for example, the first row in your table will be at index 0, but it will likely be at row 2 in Excel.
Finally, you also need to make sure to delete the matched row from the data table variable as well, so that the data table matches your Excel file after deleting the row. You can do that by using Delete row from data table to delete the row at %RowIndex% (no need to increase it by 2 in this case).
So, in general, your flow should look like this:
You can also just copy the entire code below and paste it directly into your flow designer in PAD to have all those actions created automatically for you:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''G:\\Documents\\SL_TESTE.xlsx''' Visible: True ReadOnly: False Instance=> SuppressionList
Excel.GetFirstFreeRowOnColumn Instance: SuppressionList Column: $'''A''' FirstFreeRowOnColumn=> FirstFreeRowOnColumn
Excel.ReadFromExcel.ReadCells Instance: SuppressionList StartColumn: $'''A''' StartRow: 2 EndColumn: $'''A''' EndRow: FirstFreeRowOnColumn ReadAsText: False FirstLineIsHeader: False RangeValue=> DataSL
Excel.CloseExcel.Close Instance: SuppressionList
Variables.RetrieveDataTableColumnIntoList DataTable: DataSL ColumnNameOrIndex: 0 ColumnAsList=> DataSL
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''G:\\Documents\\Extract_TESTE.xlsx''' Visible: True ReadOnly: False Instance=> BD
Excel.GetFirstFreeRowOnColumn Instance: BD Column: $'''A''' FirstFreeRowOnColumn=> FirstFreeRowOnColumnBD
Excel.ReadFromExcel.ReadCells Instance: BD StartColumn: $'''A''' StartRow: 2 EndColumn: $'''A''' EndRow: FirstFreeRowOnColumnBD ReadAsText: False FirstLineIsHeader: False RangeValue=> DataBD
LOOP FOREACH CurrentItem IN DataSL
Variables.FindOrReplaceInDataTable.FindItemInDataTableByColumnIndex DataTable: DataBD AllMatches: True ValueToFind: CurrentItem MatchCase: False MatchEntireCellContents: True ColumnNameOrIndex: 0 DataTableMatches=> DataTableMatches
IF DataTableMatches.RowsCount = 0 THEN
NEXT LOOP
END
Text.ToNumber Text: DataTableMatches[0]['Row'] Number=> RowIndex
Excel.DeleteRow Instance: BD Index: RowIndex + 2
Variables.DeleteRowFromDataTable DataTable: DataBD RowIndex: RowIndex
END
Excel.CloseExcel.CloseAndSave Instance: BD
