Hi, I am working on a volunteer data set for a non-profit. I want to keep rows in which “sign_in_date” is equal to the “shift date” for their volunteer job. I tried using “filter by rows”, but I have not been able to make it work with that field. Both dates have the same format. Any suggestions? …

Hi @Sindy_de_la_Torre_Pa , Can you send an example of your Filter rows step settings? It should be able to filter down if the string is exactly the same in both columns. There are some instances where comparison operators don’t work well with dates. In that case, we may need to reformat your dates …

Hi Daniel, Thank you so much for reaching out! In this example all of the data is yesterday’s data so this step is actually not need it, but I need it for the weekend parabola. [image002.jpg] [image003.jpg] [image004.png]

Hi @Sindy_de_la_Torre_Pa , Thanks for sharing! It looks like you’re trying to pass the dynamic value of the column as the matching string. The Filter rows step can only work with literal values. Instead, use the Insert if/else column to create a new column and fill it with a value of Yes if the dat…

Daniel, Thank you! That is a genius work around! [image004.png]

Filter rows by values being equal in two columns

Ask a question

brian July 13, 2022, 4:59pm 6

Just wanted to follow up on this thread to say that this is now possible with the Filter Rows step! A new an improved way to Filter Rows!

Topic		Replies	Views
Row Filter based on a date field Ask a question	2	496	July 24, 2020
Filter rows based on the "Today's" date Ask a question Building-Flows	3	825	May 28, 2020
Find Overlap not working with dates Ask a question Building-Flows	9	1023	April 8, 2023
A new an improved way to Filter Rows! Announcements	3	539	January 2, 2024
Filter rows based on last 24 hours Ask a question Using-APIs , Building-Flows	1	486	September 7, 2020

Filter rows by values being equal in two columns

Related topics