You can select one or more fields (columns) or All. It would not search the whole sheet to see if the duplicate exists elsewhere. In the columns area, select or check the field (s) containing the duplicates you want to remove. Cells (i + 1, 3).Value Then This only works if the rows are directly one after the other. Assuming your data set or list has headers, ensure My data has headers is checked. Here u need to use one temp collection where u store current row of collection. Select Remove Duplicates in the Data Tools group. If flag is false for this add action to enter data in queue. Message 1 of 4 13,991 Views 0 Reply 1 ACCEPTED SOLUTION v-lili6-msft Community Support 08-13-2018 03:18 AM Hi Mahi1989 You use Merge Queries function in Edit Queries.

Next Add decision Stage below action and check for flag if flag is true we will not add this data to queue just skip this and add link back to loop start. the the rows with the exact same values in each column. Now use collection loops we will add collections data to queue one by one.Īdd Action stage in loop stage select business object work queue->select action -> Is Item In queue.Ĭreate output data item which is flag type. Suppose we would like to highlight the duplicate rows, i.e. I wanted to delete every 2nd and 3rd row from that entire table.

If I use Remove duplicates over that column then it will remove only data from that column and not the entire row. First you have to create a new queue enter key name field, the column name of your collection for eg Name or Id.We will remove remove duplicate data which contains same name or Id. I had a lot of rows and what I wanted was to delete the rows containing duplicate values of a column. To delete duplicate rows, filter out zeros from Columns B and C.

Excel remove duplicate rows all columns