Issue with generating sequential numbers based on attribute values in FME

Thank you very much, excellent explanation!

Hello @geomancer​ ,

Considering that you have already successfully answered my question, I would like to ask you about another issue I have. I would appreciate it if you could help me if you know how.

I have a main table called "Documents". I need to create a table called "List" based on data from the "Documents" table. Within the "Documents" table, I have a column called "ElaborationType," and within it, the number 1 represents the main document. Numbers 6, 14, 33 represent documents related to the main document, i.e., they are lists. My goal is to generate results in the "List" table where the "RecordID" in that row matches the "ElaborationType" equal to 1, but it also repeats or duplicates that number based on the numbers 6, 14, 33.

(EXAMPLE: 2302(6), 2304(MAIN DOCUMENT NUMBER 1), 3177(14) belong to the same group because they are in the same cadastral municipality KO_ID).

Within the "List" table, I need to have 2304, 2304 because they are lists for the main document 2304, and they must have their corresponding year from the "FromYear" attribute.

Is it somehow possible to solve this problem using the FME Desktop program? I would be greatly thankful if you could provide assistance. I have provided you with an image of the main table as an example for you to see a sample of the data. I need to do this for the entire dataset; I described just one example, but in the image, you can see that I need to apply this process to the entire dataset.

Hi, if I understand correctly, this can be done with a ListBuilder followed by a ListSearcher.

Next time, could you start a new question? That makes the question and the solution easier to find for other users.

It's very similar to what you've done, but here's a slightly better example for you to see how I need the "List" table to look. In this example, you can see exactly what I need to achieve. I simply need to extract the lists from the documents and assign them the "RecordID"(ZapisID) that belongs to the main document number 1, as all these numbers, 6, 14, 33, are subordinate documents to that main one. The attribute "FromYear"(IzGodine) represents the year of data creation. This presents an issue for me because doing this manually would consume a significant amount of time.

I have already asked the question on the FME Forum as well. Here is the link: https://community.safe.com/s/question/0D5Dm00000s65epKAA/creating-a-new-table-from-the-main-database-based-on-attributes

Thanks, I will continue my answer under that queation.