Forum Discussion
Solved
Create a Table With Data From Other Tables
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...
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.
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.
VasTg thanks, it looks like it is exactly what I need.
But where should I enter this code?
"Enter Data"?
"New Source" ...?
