Automating excel data remove data columns with similar values rows

Help Activities
, ,
1

image
image1085×271 20 KB

for anil remove duplicates with “status” pending
if “status” both of them are closed get the records with “final status” as review
delete the records with “final status” as closed.
if the “status” is open get all the records with “final status” as closed as well.
if both the “final status” is closed get one records with latest received
final result output
image
image1082×202 7 KB

2

you can use remove duplicated,
1-Read range
2-Remove duplicate
3-Write Range

3

first i have to find the values in “id” column are repetative if they are repetative i need to remove based on the above conditions

4

yes, you need do this

5

how can i achieve it

6

you need to make a for each row, collect the id and put them in a collection, and put a if “if id exist in collection remove the line”

7

Hey @sameer_khan1

Sorry, The logic rules you mentioned above is not clear to me

Could you please clarify.

Thanks
#nK

8

we find the values repetative in “id” columns that values are to be removes meaning entire row based on the conditions
for first conditions remove duplicates with “status” pending
if “status” both of them are closed get the records with “final status” as review
delete the records with “final status” as closed.
if the “status” is open get all the records with “final status” as closed as well.
if both the “final status” is closed get one records with latest received
final result output

1 Like
9
  1. Rows with duplicate id values to be removed
  2. Rows with duplicate status as pending to be removed
  3. Delete the rows with status and final status as closed
  4. Filter the rows with final status as open

Little bit of understanding of mine above.

But still it is tough to crack.

What I will suggest is let’s focus one by one…

Can you point out first condition with which you can figure out the rest

10

removing duplicates is our agenda duplicates present
in “id” columns next are the conditions how can we remove it

1 Like
11

we need to remove duplicates based on the conditions which i have mentioned
duplicates are id values repeated that repeated id values rows are to be removed based on the conditions i have mentioned in the above posts
if that id value is repeating…id value paired with status pending should be removed like that

12

Is it resolved brother ?

If not please post only the first condition you want to perform on the table.

13
  1. SortDataTable Desc (Since you need latest date)
  2. Filter datatable (With first date)
    In the activity props just pass this condition : date = dt.Rows(0)(“date”)
  3. Remove duplicates activity finally
14

Hey @sameer_khan1 ,

Try using this workflow

Main.xaml (12.5 KB)

Input:
input.xlsx (9.2 KB)

Expected Output:

image
image709×121 3.63 KB