Combine two csv fields into one mysql field

  • 5Views
  • Last Post 06 April 2020
0
votes
Lachlan Young posted this 06 April 2020

Hey,

So i am importing 4 CSV spreadsheets with sales that we recieve from suppliers every few weeks. Was wondering if its possible to combine two fields from the CSV into one in the database. I wanted to combine the Order No & Line No as that will now be a unique ID we can use to ensure we do not import any duplicates.

Just wondering if this is possible within Skyvia, if not i can merge them before uploading the CSV into our FTP box

Thanks

 

0
votes
Mariia Zaharova posted this 06 April 2020

Hello!

 

We have answered you by email.

 

Best regards,

Mariia

Close