i’ve to delete particular row which is repeating i’ve to retain the first row value and delete the rest
Please check this link:
You can use - Remove Duplicate Rows Activity
Please refer this page for further details:
Other helpful source from @HareeshMR
we have an inbuilt activity now. Also check the below one -
i’ve to delete one particular value not all other duplicats
You mean you want to delete the duplicate of one particular row and leave the rest?
Go with VB code to do the required @Pradeep_Shiv
exactly ,how do i do that
- Loop through the headers of the excel
- check for the particular header you have
- Initialize the variable of type integer and then assign it to 1
- Continue the loop and if the same value occurs again, increment the value by 1 and then delete the entire column so that you will remove the second occurrence of that header.