Programming using tables

Forum|Forum|11 years ago
October 17, 2014
3 replies
1795 views

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

Best answer by StuartBruff

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?

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

1_BPP-Example-xmcd.zip