span8
span4
span8
span4
Dear FME 亚搏国际在线官网community.
I've two datasets :
Table 1
Col1 | Col2 | Col3 |
A | null | null |
null | null | null |
A | B | null |
A | B | C |
Table 2
Col1 | Col2 |
A | Art of theater |
B | Blizzard |
C | Cute rabbit |
What I want is to transformTable 1in :
Col1 | Col2 | Col3 |
Art of theater | null | null |
null | null | null |
Art of theater | Blizzard | null |
Art of theater | Blizzard | Cute rabbit |
I began to useFeatureMergebut it seems to be "heavy artillery" for a little problem.
What is the best process for resolve this ?
Thank you for your help.
The FeatureMerger is a good solution.However it will be limiting if you don't know how many look ups you're going to need in Table 2 or columns in Table1.You can take a slightly different approach by splitting the records up by column (AttributeExploder),do a single lookup,and then re-aggregate.(we use a siilar approach to transpose data)
I've attached an example workspace (2017):table-lookup-2017.fmwt
Merge/combine attributes of the biggest geometry within target dataset feature only3 Answers
How to Apply the Same Type of Merge 18 (or n number of) times without 18 Feature Merge Transformers2 Answers
Shapefile Attribut gets mysteriously to many characters,can't join or merge3 Answers
Why are FeatureJoiner and FeatureMerger joining on UUIDs differently?2 Answers
merge but by group4 Answers
© 2019 亚搏在线Safe Software Inc |Legal