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?
Userlevel 2
+19
- Supporter
- 335 replies
-
29 October 2021
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.