• EN
Solved

Creating a new table from the main database based on attributes

M

Hello,

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.

example

icon

Best answer by geomancer 28 August 2023, 10:36

View original

11 replies

redgeographics
Rank
Userlevel 5
Badge +25

It's possible for sure, but to make it clearer, could you provide a similar example of what the lists table should look like for the records you indicated in red?

M

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.

exaple2

geomancer
Rank
Userlevel 4
Badge +36

Continuing my earlier answer given here:

You can add the results to the original features.

image

M

Thanks!

geomancer
Rank
Userlevel 4
Badge +36

You're welcome!

P.S. There are many other possible approaches, like using Adjacent Feature Attributes, or an InlineQuerier, and more. But I think the solution presented above is the most simple to comprehend.

M

I have a question, only if you could take a look. I've imported the entire data into FME with those steps. If you could check if I've done something wrong because it didn't arrange the data like you explained. Instead, the data remained the same. If you could verify, the file is attached, so if you could review and return the corrected file to me?

M

Here are the initial data. Perhaps it's important to emphasize to make it clearer that some lists (6, 14, 33) are not associated with any main document (1), but generally, I need to obtain the result as you explained in your example.

1 Attachment
geomancer
Rank
Userlevel 4
Badge +36

Hi, thank you for the data. Unfortunately I could not open your workspace, as I still use an older version of FME. But I think I may have found the problem nonetheless. Can it be you did not change VrstaElabora to VrstaElaborateID in the TestFilter, or in one of the other transformers?

image

M

I think I have a problem with the AttributeRemover transformer. It doesn't allow me to put in "ElaborationTypeID"; instead, it prompts me for something like a list. It's a bit strange; perhaps it's related to the version.12

geomancer
Rank
Userlevel 4
Badge +36

There are some differences in the attributes.

Attached please find my version of the workspace, can you try it?

M

I have successfully obtained everything correctly now with your file, thank you, this has helped me a lot.

Reply


Community Stats

28,777
Posts
109,726
Replies
36,604
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.