Hello!
I'm facing a particular challenge, and i need some help or additional development.
I would like to Join data based on multiple structures used in our company.
(e.g.: Store Structure, Financial Accounts Structure, and loads of additional structures need to deal with all the particularities of our business.)
The Store Structure has 8 Levels (columns) (S1, S2, S3, S4, S5, S6, S7, STORES)
The Financial Accounts Structure has 6 Levels (columns) (F1, F2, F3, F4, F5, ACCOUNT)
I need to Join multiple and variable fields and Variable numbers of fields.
As metrics can use any particular combination with the structures above, that would make 16,383 possible configurations of the Join Tool.
As its seems mad to build all that Joins, i would need a solution to dynamically change the Join tool configuration.
I thought something like building strings that could be imputed (with an Action) as configuration in the Join Tool:
String 1 - Fields Left String 2 - Fields Right String 3 - Number of Fields
S1, F4, F5 S1, F4, F5 3
S1, S2, F2, ACCOUNT S1, S2, F2, ACCOUNT 4
Today, we cannot input in the Join tool configuration, with an action:
- choose the numbers of Fields
- Input More Than One Field per Action Tool
If i had the possibilities above i could make a macro that changes dynamically and handles all possible variations.
Any thoughts?
Thanks in advance!!
