Loop in filter

Question

Hi Friends,

I need an urgent help regarding loop in filtering. For some reason I am unable to attach the input file but I am sharing what I exactly need.

The above screenshot is the output of the filter loop process done manually. There is a big data set from which this is filtered out. Suppose "ID" is the column where we need to put the filter and "Final ID" is the value column where we get the number which we need to filter in column "ID".

For example, I need to start my filter from "312787". Now when we filter this in the "ID" column we get the "Final ID" as "312788" again we have to filter this "312788 in the "ID" column and this process needs to be repeated till there is no match in the "ID" column or the "Final ID" column is blank.

In the screenshot we have started filtering from the bottom and in the second row we get "Final ID" as "1" then we filter it in the "ID column and we can see not the new "Final ID" in row 1 is blank, which means now the loop is complete and there is no more entry to filter in the "ID" column.

If anyone can share me a workflow which can do this loop filtering, It will really be helpful.

Raj · Answer

@deepakshaw1991 can you please explain the requirement in detail, as it is difficult to understand the clear requirement
Or add the final result expected with input

KGT · Answer

Building a sample to show this method would be hard without data, but what you are after is an iterative macro, where you will pass an ID in, that will get a row from the table, put that row to output, and grab the new ID from that row, and pass to the I output.

So, something like this: (this is not a working example, as it doesn't have data in it).

Qiu · Answer

@deepakshaw1991 
I dont quite understand that the column "Final ID" is your desired result or only as input?

Can you share the data (paste the data here if can not attach file) of Input and desired output?