I am stuck with a problem, i have a data (call it main _data) in which there are dates in a column. What I want to do is to perform some operations on it on the basis of another table containing dates(call it filter_data).
So here is the requirement, compare the main_data with each row of filter_table and increment the date in main_data if the dates in main_data and filter_data matches. So in term of programming, I have to loop the filter_data rows and compare it with the main_data in each iteration RECURSIVELY, and increment the dates in main_data.
What I am able to do till now is,
Use “Table Row To Variable Loop Start” to get the rows one by one and end it with “loop end”. And perform operation in between. Problem is that it does not recurse the data, it adds the iterative rows.
Use the recursive loops, it has two problems. 1st: How to get data row by row from filter_data. 2nd: How to auto end the loop in when data end in filter_table.
Another way around would be to avoid the loop nodes and some how use the filter_table values as an array and access the relevant indexes. But not sure how it would be achieved in Knime.
