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.
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.
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.
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.
In 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.
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.
In 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.
Above 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.
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