Combining 2 separate columns of Table1 & Table2 into a column in Table3

Hi,

I want to combine 2 separate columns of Table1 & Table2 into a column in Table3. Below I prepared an example scenario in Google Sheets:

Is this possible?

Thanks!

I solved this problem and here I am sharing if anybody else wants to do the same thing below.

This is the data structure and table design:

Here is the formula as a text for convenience:

list = (Table1.lookupRecords().categoryID + Table2.lookupRecords().categoryID);
if($id-1 < len(list)):
  return list[$id-1]
else:
  return ""

You need to adjust Table1,Table2,Table3 and vehicleID for your cases of course.

Hope that helps somebody like me :slight_smile:
You can ask me on Twitter if you are stuck, I can try to help: https://x.com/_burakkurkcu

2 Likes

Has anyone been able to repeat this example?
Doesn’t work for me.
https://docs.getgrist.com/ePDYEYrDy2Ux/Union?utm_id=share-doc

Your formula in Union table’s B column is right, but doesn’t have enough rows to show it. Just add some more blank new rows to the Union table like as in screenshot below, and it will be ok.

1 Like