What i want to do is:
list all excel rows
filter by rows where column N is equal to N or W
Search through a data store for records where a value is equal to 0 or another is equal to SL
then filter by rows in excel where column CE is equal to the key in the data store
I cannot figure out how to use iterators and aggregatorsd to map the functions with the least amount of data usage and operations.
Then it looks like you might have to put the data store before the Excel module.
Does the Excel module allow you to insert search filters directly into it?
If not, instead of “List Worksheet Rows”, you might also want to try “List Table Rows”.
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
So originally i did have the data store before the excel module. The issue with that though is that it would iterate through each data store and search through excel which was sucking up all my data transfer amount.
I checked the “list table rows” it is showing the same thing as the “list worksheet rows”
