Hi there,
I have two tables, with identical structures. I need to create a third table that has all rows from both tables.
For example, let table 1 be:
A B
1 Name Age
2 John 20
3 Peter 15
And table 2:
D E
1 Name Age
2 Mary 23
3 Ann 21
Then I would have table 3:
John 20
Peter 15
Mary 23
Ann 21
In Google Sheets, I achieved that with a formula such as
={A2:B3;D2:B3}
But that gives a 539 error in LO.
Thanks
The inline array ={A2:B3;D2:B3} (probably you meant ={A2:B3;D2:E3}) is using ranges and not using constant strings/values and therefore is not compliant to the OASIS ODF standard, which states in Chapter 5.13 - Inline Arrays specifically:
Note: Expression authors should be aware that use of Expression other than constant Number or constant String may impair interoperability.
=> Google Sheets is addressed by this Note and that’s why you get an error 539, which is according to LibreOffice Help - Error Codes an Unsupported inline array content
For some uses, the Data - Consolidate tool can circumvent the limitation.
For most purposes it is better to keep all data of the same kind (e.g. info related to “person”) in a single table and use extraction tools (filters, lookup, etc.) to produce the subsets you need. Less intuitive, but more reliable.