Hello everybody,
i have the following table, which includes different dimension types and corresponding dimension data:
| Dim_Type | Dim_Index |
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 2 | 2 |
| 2 | 3 |
Based on this i need to create the following table, which has Dim_Types as header and includes all combinations of the Dim_Index in the rows:
| Dim_Type_1 | Dim_Type_2 |
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 2 | 1 |
| 2 | 2 |
| 2 | 3 |
Currently i am achieving this by using multiple filter and append field tools. But as the solution has to work for different datasets with different dimension types, i would like to do it dynamically so it automatically works for more dimension types.
Is there a "smarter" way to dynamically append the fields to generate this table?
Thanks!
