Skip to main content
Question

Merging feature


Forum|alt.badge.img

Hello,

I have 4 data sets, parcels(polygon), parcel numbers(point), building(polygon) and building numbers(point). On output end i need to have 1 data set (polygon) combined from all 4 input data sets with attribute table. I assigned parcel numbers to parcels using NeighborFinder, and building numbers to building using another NeighborFinder. Now i need to combine Parcels and buildings into one data set.

I have exception where building is a parcel and in this case i need to have parcel_id and building_id in attribute table, i any other case parcel have parcel_id but building_id need to be null or missing, and buildings building_id and null or missing for parcel_id. I tried FeatureMerger but i don't have any attributes to join on to. When i connect my outputs to inspector i get closely what I need, is there any transformer that do what inspector does?

4 replies

Forum|alt.badge.img+1

hi @luckym - check out the InlineQuerier transformer - it lets you join multiple datasets in your workflow using SQL. So each input dataset becomes a table in the temporary database (SQLite), and then you can write SQL statements to define the output(s)


takashi
Supporter
  • April 20, 2018

Hi @luckym, I don't think you need to add any other transformers to the workspace, since the Inspector has output your desired table to FME Data Inspector already. Try replacing the Inspector with a writer feature type to write the table into a single dataset.


Forum|alt.badge.img
  • Author
  • April 20, 2018
1spatialmary wrote:

hi @luckym - check out the InlineQuerier transformer - it lets you join multiple datasets in your workflow using SQL. So each input dataset becomes a table in the temporary database (SQLite), and then you can write SQL statements to define the output(s)

Thank you @1spatialmary, this transformer will be very useful. I will not yet accept your answer just in case someone else has any other idea.

 


Forum|alt.badge.img
  • Author
  • April 20, 2018
takashi wrote:

Hi @luckym, I don't think you need to add any other transformers to the workspace, since the Inspector has output your desired table to FME Data Inspector already. Try replacing the Inspector with a writer feature type to write the table into a single dataset.

Hi @takashi, I need to do some additional work before i can write out my data that is why i need my data in one dataset before writing out, but thank you for your answer.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings