Dear FME community.
I've two datasets :
Table 1
Col1Col2Col3AnullnullnullnullnullABnullABCTable 2
Col1Col2AArt of theaterBBlizzardCCute rabbitWhat I want is to transform Table 1 in :
Col1Col2Col3Art of theaternullnullnullnullnullArt of theaterBlizzardnullArt of theaterBlizzardCute rabbitI began to use FeatureMerge but it seems to be "heavy artillery" for a little problem.
What is the best process for resolve this ?
Thank you for your help.
I think the FeatureMerger would be a good choice, personally.
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