I use EDT with great pleasure, and many good results are obtained.
However, there is one non-trivial task, at least it seems so to me, so I ask for the help of specialists. Of course, I do not know if it is possible to solve this problem without complex programming, but I decided to ask this question on the forum. I would be very grateful if someone would tell me.
Brief description of the task – it is necessary to compare two tables and, if certain conditions coincide, create table 3, or create table 4.
The original tables are quite similar, but one has additional data.
The main table 1 is compared with table 2, which has an additional column Year.
It is necessary to compare the value from Object 1 (table 1) with the value in Object A (table 2), and then sequentially the values of Subobject 2, Subobject 3, Subobject 4, Subobject 5 (table 1) with the values of Subobject B, Subobject C, Subobject D, Subobject E (table 2). If there is more than one match, put the Subobject in a separate column Result (Named Subobject 2-5 = B-E). Also, add the Year column to table 3 with the corresponding value.
If a comparison between Subobject 2, Subobject 3, Subobject 4, Subobject 5 (table 1) and Subobject B, Subobject C, Subobject D, Subobject E (table 2) does not reveal any matches, then create a new table 4 in which to show a match between Object 1 and Object A, and add the Named columns galaxies and Year&
Examples of input data are shown in galaxies.transform, the desired forms of output tables are also given there.
galaxies.transform (5.0 KB)