CSV Looper, iterate over specific rows only

Hi there - I’ve integrated a CSV looper and it’s working great, however I’m missing one piece. My CSV file contains about 220 rows. I want to show the top 10 rows only where column D equals a specific value, for example “testB”. So if rows 1-100 have column D with value “testA” and rows 101-220 have a column D value of “testB”, I want the looper to grab only rows 101-110.

Is this possible?

Hello @webdesignteam,

Thanks for writing in!

Yes, it is possible. You can utilize the String Condition column D IS “testB” in the Looper Consumer element.

Kindly let us know how it goes.

Hi @ruenel, I did give this a try the first time around, however it’s not showing any items. I think this is because logically it is loading all 220 rows, and hiding the first 10, as they don’t match on this column.

Hey @webdesignteam,

I would love to check your site. Please provide us with your WP details so we can log in. You can create a secure note in your next reply with the following info:
– Link to your site
– WP login URL
– WP username
– WP password
– WP Administrator Role
– Confirmation that we can access and make changes to your site

To know how to create a secure note, please check this out: How The Forum Works

image

Thanks.

Sure thing, here you go - thanks!

Hello @webdesignteam,

Your condition should be this:

You will include the index number condition since the CSV looper does not have the ability to offset the return results.

Best Regards.

@ruenel unfortunately that won’t work for my purposes, as the CSV file will be periodically replaced automatically each month, and the rows won’t always match those conditions. I’ll work on a different workaround with the CSV file itself. I appreciate your help!

Hi @webdesignteam,

Thanks for the information. Please let us know if you need any further help with this.

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