CSV Import to Zoho

  • 19Views
  • Last Post 13 July 2020
  • Topic Is Solved
0
votes
Stuart Buck posted this 03 July 2020

Good Morning,

 

A new user to Skyvia and struggling somewhat on my first CSV import.

Background :

My CSV has all columns encapsulated in " (commas)

CSV contains some datetimes (in this example two fields) in the format "2020-07-02 00:00:00","null"

I selected the import format on these fields to DT_DBTIMESTAMP

Questions :

I am trying to do an expression on one of these fields and set another field value in the DB (also tried ISNULL)

so [End Date] == null ? "Active" : "Left"

The data types "DT_DBTIMESTAMP" and "DT_WSTR" are incompatible for binary operator "==".

 

 

 

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

Hello Stuart,

 

Please leave these fields with the DT_AUTO type and use such an Expression:

ISNULL([End Date]) ? "Active" : "Left"

 

Please tell us if this helps.

 

Best regards,

Mariia

0
votes
Stuart Buck posted this 13 July 2020

HI Mariaa,

 

I have had to raise another private ticket in the interim as my connector is no klonger working - I will review this case when we are back workign again.

Thanks

Stuart

Close