Hello, I have a list and a table. Could I create a data model between these two objects, with relationship between each list element and each element of one column in table? This leads table of list length and table length width.
Note: ignore that formula above could be applied on table2 to reduce the dimensions.
Furthermore, I would like to evaluate a function for each element of new table and run some arbitrary grouping logic on top of the results. All this in memory with data model, displaying only the last output.
For instance, row C can be grouped X for C_1 to C_2, Y for C_3 to C_7, Z for C_8 to C_10. And for these categories I want to sum up the results, for each row of original list. Final output is then original list with three columns (X, Y, Z).
I am fine if you just point me in direction where to look.
Note: ignore that formula above could be applied on table2 to reduce the dimensions.
Furthermore, I would like to evaluate a function for each element of new table and run some arbitrary grouping logic on top of the results. All this in memory with data model, displaying only the last output.
For instance, row C can be grouped X for C_1 to C_2, Y for C_3 to C_7, Z for C_8 to C_10. And for these categories I want to sum up the results, for each row of original list. Final output is then original list with three columns (X, Y, Z).
I am fine if you just point me in direction where to look.
Last edited:
