I am downloading csv data from a dropbox folder using quickbase sync.
There are about 10 csv files with the same structure which I upload into 10 tables in Quickbase. I can't upload them into one table as unique field is only unique to one particular csv file - then it might be replicated in other files.
Question - is there a way to merge all those 10 tables into one (i.e. union join) in quickbase as they are all the same? A unique identifier would be "file-name & unique-field".