Programming using tables

6 replies
1842 views
Translate All

Greetings to all.

I have a table (Table 1) with a large number of components (A1, A2, etc.) which in turn contains another large number of elements (E1, E2, E3, etc.), whose values necessary to perform operations are in another table (Table 2).

Based on the table1, I need to get the values of the elements forming part of each component (eg A1 (E1, E3), A2 (E2), etc) to perform subsequent operations.

To better understand what I want, I attached an example of what I have to do, and I want to automate as I do it manually would take me a long time because as I said earlier Table 1 has a large number of components

in advance thanks for the help

1_Example-xmcd.zip

Physics

S

StuartBruffAnswer

23-Emerald V

Bryan Pérez Pérez wrote:
Greetings to all.
I have a table (Table 1) with a large number of components (A1, A2, etc.) which in turn contains another large number of elements (E1, E2, E3, etc.), whose values necessary to perform operations are in another table (Table 2).
Based on the table1, I need to get the values of the elements forming part of each component (eg A1 (E1, E3), A2 (E2), etc) to perform subsequent operations.
To better understand what I want, I attached an example of what I have to do, and I want to automate as I do it manually would take me a long time because as I said earlier Table 1 has a large number of components
in advance thanks for the help

Do you mean something like the attached? I haven't tested it properly, but it might act as a starting point.

Stuart

M

MikeArmstrong

1-Visitor

Hi Bryan, yes I believe it will be possible, but I am not entirely sure what you how you want it automated.

Where is the selection of the component?

Translate

S

StuartBruff

Answer

23-Emerald V

Bryan Pérez Pérez wrote:
Greetings to all.
I have a table (Table 1) with a large number of components (A1, A2, etc.) which in turn contains another large number of elements (E1, E2, E3, etc.), whose values necessary to perform operations are in another table (Table 2).
Based on the table1, I need to get the values of the elements forming part of each component (eg A1 (E1, E3), A2 (E2), etc) to perform subsequent operations.
To better understand what I want, I attached an example of what I have to do, and I want to automate as I do it manually would take me a long time because as I said earlier Table 1 has a large number of components
in advance thanks for the help

Do you mean something like the attached? I haven't tested it properly, but it might act as a starting point.

Stuart

Translate

1_BPP-Example-xmcd.zip