Forum Discussion

sparkplug93751's avatar
sparkplug93751
Icon for Helper II rankHelper II
6 years ago

Relationships and Lookups

Hello,   I have one column that performs a lookup if another column matches criteria: if(category=30,"30",lookupvalue(table1(task),table1(category),task(category)   When I try and make a lookup (...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

sparkplug93751 

You can move data like this from table2 to table 1

Get from Table 2

New Column = maxx(filter(table2,table2[Col1]= table1[col1] && table2[Col2]= table1[col2] ),table2[required_col])
New Column = maxx(filter(table1,table1[Col1]= earlier(table1[col1]) && table1[Col1]= earlier(table1[col2]) ),table1[required_col])