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
Follow these steps
- Read the master sheet data in to datatable dt
- 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
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
For second step assign
For third for each data row
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
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)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.