I want to filter and change an Excel table with empty entries in column B

How To
, ,
1

I do have an Excel table. There are about 1000 rows with different columns. I want to filter all rows without a value in Col B. THere I want to set an automated value in it, for example (to simplify) the now timestamp.

I tried to use a “List Worksheet Rows” with a filter on it and an iterator after that. But I don’t see a way, to to update the filtered columns / vlaues. Can someone help me? Thanks!

2

Hello @Ralle_tb,

Understand the Basics

In a Make, there are a couple of modules that work as Specialized Iterators.
It means when you use and iterate the data without using the Iterator itself after getting multiple results this is called Specialized Iterator.

Solution

I’m not sure whether “List Worksheet Rows” works as a Specialized Iterator or not. If yes then directly use your next modules it automatically works as how an iterator works.

If it’s not a Specialized Iterator then use Iterator Immediately after “List Worksheet Rows”, then do your further module integration.
Then set your filters based on Iterator values.

I hope this solves your issues. If not then share a screenshot with your used data.

:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best Answers as Solutions :white_check_mark: and give :+1: If you need expert help or have questions? Contact or comment below! :point_down:

3

image
image1154×476 40.9 KB

image
image871×972 78.4 KB

image
image927×972 87.8 KB

I tried it this way without the seperator module. For the time beeing, I’m feeling like no idea, what I’m doing here:

  1. I tried a filter but it didn’t word. Hope I will see this later by myself
  2. The Excel list seems not to iterate
  3. I don’t know how work with the row id. Now in this case, there appears an runtime error in the end

Thanks for help