Forum Discussion
Add Attributs form another table
qwertzuiop , New Columns like this in table 2
Area = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Area])
Same way repeat other two
Location = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Location])
Group = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Group])
Thank you very much for your contribution, but I think it's not thas quick solved.
Why? Because the ID can/will occur several times in both tables, since the employee in table 1 may change the area every month and in table 2 he/she carry out a new shift every day.
So I have to check, in which time period (from-to) the date of the shift fits and matches the id.
Then it should be possible for me to tell you later, which employee performs a shift in which region based on the date.
Got it?
Thaaanks a lot.
Cheers
qwertzuiop
qwertzuiop , New Columns like this in table 2
Area = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Area])
Same way repeat other two
Location = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Location])
Group = maxx(filter(Table1, Table1[ID] =Table2[ID] && Table2[Date] >= Table1[Date_from] && Table2[Date] < = Table1[Date_to]),Table1[Group])
Hi amitchandak
Sorry for my absence.
Thank you very much for your support.
The solution you gave me here works.Have a nice day - you saved mine 😉