In the excel there is two sheets sheet1 has one column names as “Service No” and sheet two has “Service Number”. In this i want match this both column value and if the value is not matched then the data row should be remove. Please help regarding this.

@shailesh1920 , Could you try the below Steps : Read the above sheet’s First Column using Read Column Activity. Assuming that the Service Number will always start from that specific position (A2). The Output will be a collection which will contain all the service numbers present in the column, l…

How to delete the row from datatable2 which has different value from datatable1

Help Studio

shailesh1920 (Shailesh) January 8, 2023, 2:45pm 6

Above sheet having “Service Number” Column and below sheet having “Service No” Column if the service number not matched with below sheet then that row should be remove from below sheet.
Please help on this.

Topic		Replies	Views
Compare two data tables and remove not Matching rows Studio studio , question , workflow_diff	4	2199	January 5, 2022
Compare 2 column values in rows and delete the rows where these column match Activities datatable , excel , activities , question , data_manipulation	6	1773	December 28, 2021
Delete Rows from a datatable after comparing with another datatable Help	4	4467	January 19, 2020
Compare Excel file with another Help excel , activities	11	4248	November 1, 2018
Deleting an Excel Data Row if it contains the same specific data Help excel , studio	10	2265	October 27, 2019

How to delete the row from datatable2 which has different value from datatable1

Related topics