Skip to main content
Solved

How join two different output of custom transformer into one ?

  • June 1, 2021
  • 5 replies
  • 203 views
A
Forum|alt.badge.img

I am working on FME script which generated two output one is 1-1 where building outline are link to one parcel ( even if it related to multiple parcels) and another output is 1-M where building outline are link to many parcel which are relate to. Below are data inspector output of two custom transformer. which I need to joined as final output and exported to CSV. FeatureMerge i tried not giving right output.

Output1 :

Screenshot 2021-06-01 at 9.26.30 PM 

Output 2 :

 

Screenshot 2021-06-01 at 9.27.28 PM 

Expected Output after joined :

 

Screenshot 2021-06-01 at 9.28.13 PM 

FeatureMerger output : Highlighted column value is same all record which is not related to building outlines also.

 

Screenshot 2021-06-01 at 9.30.50 PM

Best answer by avinashdalvi_

Thanks @rahulsharma​ for help but I solved this problem using SpatialRelator.

 

I got answer to this question. I used SpatialRelator because both input has same type spatial data I just wanted to join between them. SpatialRelator I just comparison as Equal operator because both data is similar only difference between attribute.

SpatialRelator -> ListExploder -> Output

 

Screenshot 2021-06-07 at 4.35.56 PM

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

rahulsharma
Safer
Forum|alt.badge.img+10

hi @avinashdalvi_​ 

In your scenario, you will need to generate a list on the attribute and then use ListExploder on the Merge port. Please see the example workspace using your test data. Please implement this workflow in your workspace to get the desired result.

If you do not want the Name column, just remove it from the data using AttributeManager.

 Output

A
Forum|alt.badge.img

hi @avinashdalvi_​ 

In your scenario, you will need to generate a list on the attribute and then use ListExploder on the Merge port. Please see the example workspace using your test data. Please implement this workflow in your workspace to get the desired result.

If you do not want the Name column, just remove it from the data using AttributeManager.

 Output

This is not supported in FME 2016. Could you please share screenshot FeatureMerger setting. I tried this setting it giving 16000 record from input of 399 which not expected. Screenshot 2021-06-02 at 1.55.20 AM

rahulsharma
Safer
Forum|alt.badge.img+10

Hi @avinashdalvi_​ 

Can you elaborate a bit more on your problem, the data that you are trying to merge how many features on each data?

Do you want to get 399 records in the end? but StackedParcel attribute should contain, the id from both datasets as a comma-separated list?

If you inspect the Merge port, you should see a list attribute that should contain the data that you desire.

 

WorkspaceIn the above workflow, are you expecting, what is the value out of your merge port?

My FeatureMerger setting is exactly the same as yours but I think the issue is with the data after the merge feature.

A
Forum|alt.badge.img

Hi @avinashdalvi_​ 

Can you elaborate a bit more on your problem, the data that you are trying to merge how many features on each data?

Do you want to get 399 records in the end? but StackedParcel attribute should contain, the id from both datasets as a comma-separated list?

If you inspect the Merge port, you should see a list attribute that should contain the data that you desire.

 

WorkspaceIn the above workflow, are you expecting, what is the value out of your merge port?

My FeatureMerger setting is exactly the same as yours but I think the issue is with the data after the merge feature.

Screenshot 2021-06-02 at 2.17.24 PMAbove image is my workflow. You can see 399 result converting to 16999 after list exploder. It like 399 * 41 = 16359. Output 1 has 41 feature and Output 2 has 399 feature. I want to have final output with 399 feature.

A
Forum|alt.badge.img
  • avinashdalvi_
  • Author
  • Best Answer
  • June 7, 2021

Thanks @rahulsharma​ for help but I solved this problem using SpatialRelator.

 

I got answer to this question. I used SpatialRelator because both input has same type spatial data I just wanted to join between them. SpatialRelator I just comparison as Equal operator because both data is similar only difference between attribute.

SpatialRelator -> ListExploder -> Output

 

Screenshot 2021-06-07 at 4.35.56 PM

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.