I have 1 table that has one column called mbipk with a number value and then another column called sales with a number in it. I want to run it against 16 other tables which also have that same mbipk column, I want it to match only the mbripk number and if that matches then I want it to inject a new column called sales_2 and put the sales number from the 1st table into sales_2 into table 2. Is this possible?
Question
Join 2 tables merge data from one column after matching data in another column.
+23- Influencer
If I understand your question, I think this could be easily resolved with a FeatureJoiner.
Left would be those 16 tables and Right the first table. Once joined, create a new attribute called "sales_2" whose value would be the "sales" field of the first table.
Than do some attribute cleaning and you have your new set of 16 tables that you can write using a dynamic process.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.