Apply Join operator on each Attribute
Hello everyone,
As usual, I'm sorry if the question has already been posted before - although I carefully checked...
Here is my issue. I have an Example Set_1 containing an attribute called Date, and a variable number n of attributes called People_1 to People_n. I also have another Example Set_2 containing a list of names and biographic datas.
In order to get for each date the biographic datas of each people involved that day, I would like to apply the Join Operator to each attribute People_i (i=1 to n) using their names as Key attributes.
For now, as n is still small (7), I can do it by hand, parametring 7 Join Operators for each People attribute, and joining my 7 resulting sets in the Append Operator. But, I would like to get the same result automatically, in case of n becomes too big (parametring 40 Join Operators and connecting all them to an Append seems quite heavy and inelegant to me).
I've tried during past week to find an elegant solution to that problem, and I haven't been able to figure it. I've tried Loops of all kind, Subprocesses, etc. It seems very simple though, but I've been unable to get my "hand" results automatically.
Here are some of my datas to help you.
Thanks a lot, as always :-)
Sylvain
Row | Id | Date | People_1 | People_2 | People_3 | People_4 | People_5 | People_6 | People_7 |
12 | 12.0 | Sat Dec 19 00:00:00 EST 1970 | Loretta Lynn | Owen Bradley | ? | ? | ? | ? | ? |
13 | 13.0 | Sat Jun 07 00:00:00 EDT 1980 | Sissy Spacek | Loretta Lynn | Owen Bradley | ? | ? | ? | ? |
14 | 14.0 | Sat Dec 04 00:00:00 EST 2010 | Loretta Lynn | Sheryl Crow | Miranda Lambert | ? | ? | ? | ? |
15 | 15.0 | Sat Aug 09 00:00:00 EDT 1969 | Charley Pride | Dallas Frazier | A.L. "Doodle" | Chet Atkins | Jack Clement | Bob Ferguson | Felton Jarvis |
Row | People | Birth_date | Birth_state | Sex | Ethnicity |
2 | Charles Kelley | Fri Sep 11 00:00:00 EDT 1981 | GA | Male | Caucasian |
3 | Hillary Scott | Tue Apr 01 00:00:00 EST 1986 | TN | Female | Caucasian |
4 | Reba McEntire | Mon Mar 28 00:00:00 EST 1955 | OK | Female | Caucasian |
5 | Wanda Jackson | Wed Oct 20 00:00:00 EST 1937 | OK | Female | Caucasian |
6 | Carrie Underwood | Thu Mar 10 00:00:00 EST 1983 | OK | Female | Caucasian |
7 | Toby Keith | Sat Jul 08 00:00:00 EDT 1961 | OK | Male | Caucasian |
8 | David Bellamy | Sat Sep 16 00:00:00 EDT 1950 | FL | Male | Caucasian |
9 | Howard Bellamy | Sat Feb 02 00:00:00 EST 1946 | FL | Male | Caucasian |
10 | Keith Urban | Thu Oct 26 00:00:00 EDT 1967 | Northland | Male | Caucasian |
11 | Miranda Lambert | Thu Nov 10 00:00:00 EST 1983 | TX | Female | Caucasian |
12 | Sam Hunt | Sat Dec 08 00:00:00 EST 1984 | GA | Male | Caucasian |
13 | Johnny Cash | Fri Feb 26 00:00:00 EST 1932 | AR | Male | Caucasian |
14 | June Carter | Sun Jun 23 00:00:00 EDT 1929 | VA | Female | Caucasian |
15 | Merle Haggard | Tue Apr 06 00:00:00 EST 1937 | CA | Male | Caucasian |
16 | Waylon Jennings | Tue Jun 15 00:00:00 EDT 1937 | TX | Male | Caucasian |
17 | Willie Nelson | Sat Apr 29 00:00:00 EST 1933 | TX | Male | Caucasian |
18 | Loretta Lynn | Thu Apr 14 00:00:00 EST 1932 | KY | Female | Caucasian |
19 | Sissy Spacek | Sun Dec 25 00:00:00 EST 1949 | TX | Female | Caucasian |
20 | Sheryl Crow | Sun Feb 11 00:00:00 EST 1962 | MO | Female | Caucasian |
21 | Charley Pride | Sun Mar 18 00:00:00 EST 1934 | MS | Male | African American |
22 | Rodney Clawon | ? | TX | Male | Caucasian |
23 | Nathan Chapman | ? | TN | Male | Caucasian |