Hi all, Is there a way to update this excel file to only include rows where Form Type = "D ". The output must still contain an active link to website (SEC Link)? [image] Form D Report.xlsx (52.4 KB) ?

@Brennan_Montoni - DeleteRows_RetainLink_X.zip (197.2 KB) . Run this workflow as is, you will see the new sheet “Copied DR” gets created with only Form Type "D ". Note: This Project I have created in StudioX and later opened in Studio and ran it. That’s how i got the all the variables easily. Plu…

Remove rows from excel where Form Type = "D " and keep website links

Help Activities

saijagadesh06 (Jagadeesan) April 26, 2021, 7:13pm 2

Hi @Brennan_Montoni

I hope you should not play around the Data Table. You should play the inside the excel file, then you will get the excepted output.

Happy Learning

1 Like

Topic		Replies	Views
"filter" excel StudioX studiox , question	6	141	September 13, 2024
How to ignore if already scrapped Studio studio , question , workflow_diff	6	752	May 14, 2021
How to keep only specific rows of data in excel Studio excel , activities , studio , question	8	1744	October 28, 2022
Excel data remove Studio	2	589	October 18, 2021
Delete rows in excel if value in a column is "D" Activities excel , activities , question	18	1673	April 26, 2021

Remove rows from excel where Form Type = "D " and keep website links

Related topics