Forum Discussion

Pandadev's avatar
Pandadev
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Create a summary table from 60 tables not all in same format

Hi I have 60 tables that I need to create a summary table from , the tables are not formatted the same. With different amounts of columns and named columns. But each table has a Column called QC Chec...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Pandadev , Not very clear

    Try like

    union(
summarize('QC Check 1', "Table","QC Check 1", "Rows",countrows('QC Check 1')),
summarize('QC Check 2', "Table","QC Check 2", "Rows",countrows('QC Check 2')),
summarize('QC Check 3', "Table","QC Check 3", "Rows",countrows('QC Check 3')) // so on
)

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Pandadev , Not very clear

Try like

union(
summarize('QC Check 1', "Table","QC Check 1", "Rows",countrows('QC Check 1')),
summarize('QC Check 2', "Table","QC Check 2", "Rows",countrows('QC Check 2')),
summarize('QC Check 3', "Table","QC Check 3", "Rows",countrows('QC Check 3')) // so on
)

 

Pandadev's avatar
Pandadev
Icon for Post Prodigy rankPost Prodigy
6 years ago

Thanks that worked perfect , I just changed "Table" to "QC Check" as noticed that was the column header name , same for "Rows"