Skip to main content
  • EN

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?

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)

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 @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.

 

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.

Reply


Community Stats

30,469
Posts
115,713
Replies
38,289
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.