Combine two csv fields into one mysql field

  • 31Views
  • Last Post 4 weeks ago
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

 

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 06 April 2020

Hello!

 

We have answered you by email.

 

Best regards,

Mariia

0
votes
Nis Lorenzen posted this 4 weeks ago

If the support forum should work as intended, please keep your answers in here instead of emailing.

0
votes
Mariia Zaharova posted this 4 weeks ago

Hello Nis,

 

This request was sent to us both by email (with some additional questions) and on the forum. All further correspondence was conducted individually with the client by email.

If this question is also actual for you, we will be happy to provide you with assistance.

 

Best regards,

Mariia

Close