Remove from excel 1 when column in excel 2 = Y

Help Studio
, ,
1

Hi,

I have two excel spreadsheets, both of them contain column “ID” and these match. However, I want to delete the row from excel 1 when a column in excel 2 is equal to “Y”.

see examples attached

image

image
image445×521 8.62 KB

2

Hello @aquinn, Try this

  1. Read excel 1 and 2, and store them as a DT1, DT2 Variable.
  2. Use filter data table activity, and store then in DT3
    image
    image751×539 20.3 KB
  3. Use For each Data table activity and loop the DT3
    3.1 Use filter activity in it.
    3.2 Pass Input and output as a DT1
    3.3 Select the Remove option and refer the below Screenshot
    image
    image730×507 20 KB
  4. Write the DT1 in different Excel sheet using write range activity.
3

Hello, thank you for this.

Would it be possible to attach your workflow here?

4

If you provide a Sample Excel sheet, i will send workflow using the Excel sheets

5

I have used this and it works now, thank you!

6

@aquinn
Happy Automation :smile:

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.