Get value for on table to another "huge" data , low memory

[Wresen]

Hi and thx for readig this.

I have a problem that i get to low memory when i try to move (lookup) value from one table to another
i have 32 gig ram and 64 bit client
one table is around 4 gig , and the other is 5 gig.

My formula looks like this in table4gig

Value = Calculate(max(table5gig[value]),

Filter(table5gig,table5gig[startdate] <= table4gig[date] &&  table5gig,table5gig[Endate] > table4gig[date]))

Is there any other way this can be done so i dont get low memory ??

/Thanks so much

[amitchandak · Accepted solution]

@Wresen , Across Table Operations, can be really costly, so try to avoid that.

I am hoping this is calculated column

Calculate(max(table5gig[value]),

Filter(table5gig,table5gig[startdate] <= table4gig[date] && table5gig,table5gig[Endate] > table4gig[date]))

is there any other key or condition which can reduce access of the complete table like group/category etc

Another option to bring that column from source

[Wresen]

Hi @amitchandak 
Yes its a calculate column (created a new column in "table4gig" and the code is inserted there)

There is on more that i could add but i does not help [ID]

Calculate(max(table5gig[value]),

Filter(table5gig,table5gig[startdate] <= table4gig[date] && table5gig,table5gig[Endate] > table4gig[date] && table5gig[ID] = table4gig[ID]))

EDIT:
It works when i do it like this: (did not understat that the order of the "filter" was that huge impact)

Calculate(max(table5gig[value]),

Filter(table5gig,table5gig[ID] = table4gig[ID] && table5gig[startdate] <= table4gig[date] && table5gig,table5gig[Endate] > table4gig[date]))