Tall Tables and Logical Matrices

Hello,

im trying to do this:

[i,j] = find(zensus.FLW==floorarea.FLW'&zensus.ZLW==floorarea.ZLW');
zensus.FLA(i) = floorarea.FLA(j);

(Link to original question)

but with tall tables. I created them with the tall() function because I get the 'out of memory' error.

When I try:

[i,j] = find(zensus_tt.FLW==floorarea_tt.FLW'&zensus_tt.ZLW==floorarea_tt.ZLW');
zensus_tt.FLA(i) = floorarea_tt.FLA(j);

I get the error that tall tables cannot be transposed.

Does anyone know a workaround? Any help would be incredible!

Answer 1

[Bruno Luong]

Please try this

[tf,j] = ismember([zensus.FLW zensus.ZLW],[loorarea.FLW floorarea.ZLW],'rows');
i = find(tf);
j = j(tf);
zensus_tt.FLA(i) = floorarea_tt.FLA(j)