You have the keys for both tables, is there any reason you can't do a get, 
local append, put?
If you do it in batch, then running a reduce job that collects all of the keys 
for a given value would be fairly efficient.

Dave


-----Original Message-----
From: Vishal Kapoor [mailto:[email protected]] 
Sent: Tuesday, April 12, 2011 8:29 AM
To: [email protected]
Subject: Append value to a cell?

Do we have any API which can append text values or row Ids to a cell.

I want to do a control break report and want to append row Ids to a
cell value...
here is an example.

TableMain
row1 : user1
row2: user1
row3 : user2
row4 : user3


reverse lookup.
TableRLookup.
user1 : row1,row2
user2: row3
user3: row4.

now I get some more data.

row5 : user4
row6 : user1
row7 : user2
row8 : user3

now I want my lookup to get updated incrementally, not the entire run.
TableRLookup.
user1 : row1,row2,row6
user2: row3,row7
user3: row4.row8
user4: row5

my rowIds are String.,

how can we do this without rebuilding the entire reverse lookup time
from ground up.

thanks,
Vishal Kapoor

Reply via email to