How to combine multiple tables with the same table structure into one table?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Hi Community,

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".


Thanks.

Dmitry

Photo of Dmitry

Dmitry

  • 0 Points

Posted 3 years ago

  • 0
  • 1
So, if you had 10 tables each with 100 records each are you simply looking to copy them all to a single table with 1,000 records.  ie each record stays separate?
Photo of Dmitry

Dmitry

  • 0 Points
Exactly. And all 10 tables have the same list of fields.
Here is an app xsmole if a URL formula button to consolidate the data from multiple tables into one

var text URLONE = URLRoot() & "db/" & [_DBID_CONSOLIDATED_TIMES] & "?act=API_PurgeRecords";
var text URLTWO = URLRoot() & "db/" & [_DBID_CONSOLIDATED_TIMES] & "?act=API_RunImport&ID=10";
var text URLTHREE= URLRoot() & "db/" & [_DBID_CONSOLIDATED_TIMES] & "?act=API_RunImport&ID=12";
var text URLFOUR = URLRoot() & "db/" & [_DBID_CONSOLIDATED_TIMES] & "?act=API_RunImport&ID=13";
var text URLFIVE = URLRoot() & "db/" & [_DBID_CONSOLIDATED_TIMES] & "?act=API_RunImport&ID=14";
var text URLSIX = URLRoot() & "db/" & [_DBID_CONSOLIDATED_TIMES] & "?act=API_RunImport&ID=15";
var text URLSEVEN = "https://gateways.quickbase.com/db/bhz2dk3kp?a=showpage&pageID=30";


$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
& URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIVE))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX)))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSEVEN))))))


So the idea is to build saved table to table imports and then run them all after first purging the target table.