🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Apply Join operator on each Attribute

User: "SylvainM"
New Altair Community Member
Updated by Jocelyn

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

Find more posts tagged with