Importing info from two separate CSV files into one Table and matching up the right info to eachother?

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
I have information on 2 separate CSV files that I want to end up on one table in QuickBase. The common link between the information in the 2 CSV files is the "PO Number" field. What is the best way to upload both files so that the right info from one CSV file ends up with the corresponding info on the other CSV file?
Photo of cs5469

cs5469

  • 70 Points

Posted 1 month ago

  • 0
  • 1
I am assuming the "PO Number" is the primary key on the table you are importing into. As long as that is true, you can import from the files one after the other. Quick Base will automatically merge the data from the two csv files.
Photo of cs5469

cs5469

  • 70 Points
No see i figured that would be the way to go but for some reason it isn't merging the info, just creating new records for the info from the 2nd file. I must be doing something wrong. When uploading the 2nd file of data, i select to use the "PO Number" as the existing field for the PO Number field on the 2nd file and then leave the rest to create new fields. I thought it would then go look for that PO# in the existing records and add the new info to the corresponding record. Is it because there are multiple existing records with the same PO Number? Or am I just doing it totally wrong?