Delete the full row using condition

Help Studio
, ,
1

compair the master file and input file.
if same data are present in input file of ‘ALT_ID’ column, then delete the full rows.

in excel file there is 2 sheet
in one sheet there is one colume name =id
in second sheet there is same colume =id
but in 2 sheet there is some id
i have to do in excel file sheet 1 is delete the full row using second sheet id

2

Hi @purnima_mandan

Follow these steps

  1. Read the master sheet data in to datatable dt
  2. Dt.AsEnumerable().Select(function(x) x(“id”).Tostring).ToArray.distinct().ToArray in to array variable(arr) will give you all the distinct id values from master id
    3 now use for eqch row in excel and loop through the input file and use insert/delete rows activity to delete the row inside a if condition arr.contains(currentrow id value from for each row)

This is if you want to do it only on excel

Else read both to datatables and then loop on the unique id’s and use filter datatable to get the rows not matching

Cheers

3

first i have to use read range workbook activity
after that i give sheet name as First sheet name value
after which activity i have to use

4

@purnima_mandan

For second step assign
For third for each data row

5

Book.xlsx (9.6 KB)

this is my excel file

compair the sheet and file1 in excel file.
if same data are present in input file of ‘Customer_ID’ column, then delete the full rows

can you do this program please in your studio

6

@purnima_mandan

PFA a sample.

I followed the same steps as above . Only one change is used for each instead of for each excel row . Rest all is same

filter.xaml (15.0 KB)

cheers

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.