Create a Table With Data From Other Tables

[BIGedem]

Hey guys,

I currently have 3 tables with different data.

I need a new table, with two columns, where data is displayed like this:

             Column 1            | Column 2

Row 1 | Name of table1* | Number of rows on table 1

Row 2 | Name of table2* | Number of rows on table 2

Row 3 | Name of table3* | Number of wors on table 3

* manually inserted

How could I create this table using formulas in order to update the values when I update the data?

[VasTg · Accepted solution]

@BIGedem 

If you only have 3 tables, I would create a new table as below.

 New_table =

VAR TABLE1 = "TABLE1"

VAR TABLE1_COUNT = COUNTROWS('Table1')

VAR TABLE2 = "TABLE2"

VAR TABLE2_COUNT = COUNTROWS('Table2')

VAR TABLE3 = "TABLE3"

VAR TABLE3_COUNT = COUNTROWS('Table3')

RETURN UNION(ROW("Table_Name",TABLE1,"Row_Count",TABLE1_COUNT),

ROW("Table_Name",TABLE2,"Row_Count",TABLE2_COUNT)

ROW("Table_Name",TABLE3,"Row_Count",TABLE3_COUNT))

If this helps, Mark it as a solution.

Kudos are nice too.

[BIGedem]

@VasTg thanks, it looks like it is exactly what I need.

But where should I enter this code?

"Enter Data"?

"New Source" ...?

[VasTg]

@BIGedem See the attachment.

Ignore the error as I don't have table2 and 3 in my test.

If it helps, mark it as a solution.

Kudos are nice too.

[BIGedem]

Thank you!!

It worked. 😀