aartist has asked for the wisdom of the Perl Monks concerning the following question:
Dears,
I have Table 1 and Table 2.
Column A in Table 1, have "values" in Table 2 ( columns P,Q,R). I like to merge these values and produce table 3, replacing entries in column A. An entry in column A can have multiple values as seen in Table 2 for A=1. In Table 3, columns B and C are almost same as that in Table 1, but they take care of 'multiple values for column A'.
I have Table 1 and Table 2.
Table:1 A B C 1 0 2 0 1 3 Table:2 A P Q R 1 1 0 1 1 0 1 0 0 0 0 1 Table:3 B C P Q R 0 2 1 0 1 0 2 0 1 0 1 3 0 0 1Each Table has columns. I am looking to produce Table 3 from Table 1 and Table 2. See that Column A is listed in Table 1 as well as in Table 2.
Column A in Table 1, have "values" in Table 2 ( columns P,Q,R). I like to merge these values and produce table 3, replacing entries in column A. An entry in column A can have multiple values as seen in Table 2 for A=1. In Table 3, columns B and C are almost same as that in Table 1, but they take care of 'multiple values for column A'.
Please also note that column A can have
multiple entries for same number (Here A=1) in Table 1 as well.
example:
Table:1 A B C 1 1 1 1 0 2 0 1 3 Table:2 A P Q R 1 1 0 1 1 0 1 0 0 0 0 1 Table:3 B C P Q R 1 1 1 0 1 1 1 0 1 0 0 2 1 0 1 0 2 0 1 0 1 3 0 0 1
How should I go about this? Any Data/Table/Matrix modules can help?
Thanks.
Back to
Seekers of Perl Wisdom