0

how do I combine multiple tables into one new table? And - what is the best way to clean up duplicate records?

I've been keeping records in a separate file for each year.  I decided it would make more sense to just keep one table covering all years.  So I tried (and failed) to import each table into my new table.  I now have duplicate entries in each yearly table, and no data in the new table.  Format and structure is the same for all tables. So...

1) What is the best way to combine tables into one?

2) What is the best way to delete duplicate records in each table?  I am currently selected each row, closing the record pop-up, and selecting the next row, etc then right click and select delete rows.  Takes forever since every time I select a row, the record pops up, blocking the remaining records.  Any way to stop the record from popping up after being selected?

4 replies

null
    • Alexander_Koenig
    • 5 yrs ago
    • Reported - view

    Hi,

    first step would be to export everything in CSV files. In the second step you import all these files into one table.

    Let me know if this helps.

    Best regards, Alex

    • rh71
    • 5 yrs ago
    • Reported - view

    I'm totally confused by ninox. how do i do a simple sql query? I want to combine 2 tables wth an inner join. struggling to work out how to do that or if its even possible in Ninox. cheers

    • Mconneen
    • 5 yrs ago
    • Reported - view

    To avoid the pop up...  toggle to the table view .. then select the desired record .. and click delete.. Still does only one delete at a time tho. tableView

    • pukfan
    • 5 yrs ago
    • Reported - view

    Thanks all for the help.  Both questions answered (CSV export/import, and Table view).  

Login to reply

Content aside

  • 5 yrs agoLast active
  • 4Replies
  • 3271Views