I am currently working on a workflow that involves multiple Date&Time-based Row Filter nodes. The start and end dates for these filters need to be set using variables derived from a Table Creator node, specifically from the start_date and end_date columns.
Here’s what I’m trying to achieve:
I want to iterate over each row of the Table Creator node, changing the start and end dates with each iteration. This means that the input for the Date&Time-based Row Filter node changes with each iteration.
I want to end the loop when all entries in the Table Creator node have been exhausted.
Finally, I want to collect the results of all iterations in a single table.
Here’s the challenge I’m facing:
The result of each iteration is saved in the same column. I want to save it in its different column of iteration(I already tried Loop end Column append, isn’t working). I wanted to Iterate to all dates of the month to get the result of each date.
Also, suggest me to convert this for all months of the year with an easier method. Changing entries in Table creator for variables is not feasible every time.
Furthermore, it’s just a part of my workflow which contains multiple datet&time based row filter nodes which are doing the same thing but with parameters other than attendance, and I wanted to save them in different columns. I will post that problem too when this one is solved
You could do a column rename before loop end and use the iteration # in the column name. The iteration number will be present as a variable and there is an option to include it in a column in the Loop End node.
how to do this particular task cause I think this might actually work cause right now my rows are vertically stacked instead of horizontally, meaning like this I and I want the above-mentioned format.
I achieved the required format using loop end(column append) node but the problem is they have random column names and they still are up and down not at the same height
It looks like the vertical format you had should have worked if you used the Pivot node and Grouped on Row ID and Iteration, Pivoted on the Date, Then calculated the value column using First or Sum. (Shouldn’t matter as long as you don’t have unique row ID numbers)
I won’t be able to open your workflow directly for a few days since I am on vacation, otherwise I would just upload a solution to show you.
When you pivot, the columns that you Group by will remain “fixed”. I would recommend waiting to pivot until after the loop end first if you can make that work. It will be easier that way.
thanks that worked. I grouped by ids. The only thing that remain is that renaming the columns which is tricky part cause I want them to variable and change according to the dates in table creator rows. I’ll search the method. Thanks for help
