Forum Discussion

bill_sturdivant's avatar
bill_sturdivant
New Contributor III
7 years ago

Substring a field inside of an array?

I’m trying to substring the field $studySiteChecklist.checklist.lastUpdateDate but I can get it to keep the same output as the input. Any ideas? [{ "country": "a", "studySiteChecklist": { "c...
vbetharasi's avatar
vbetharasi
New Contributor
6 years ago
Copy LinkReport

Hi,
I don’t understand what is the exact issue. Can any one help here please as this is on priority . It’s very urgent

Thanks,
Venu

anubhav_nautiya's avatar
anubhav_nautiya
Contributor
6 years ago
Copy LinkReport

Hi, can you try this:

When connecting to an SSL enabled PostgreSQL account, the account fails in validation. To overcome this, configure the URL properties in Account settings to establish an SSL connection with the following parameter and value:

URL property name URL property value
sslmode require

or try

URL property name: ssl
Value: true

  • Ajay_Chawda's avatar
    Ajay_Chawda
    Contributor
    5 years ago
    Copy LinkReport

    Hi jervin,

    Please uncheck “Contains Headers” check box and set skip line =1 (assuming first line of file contains header information )

    Please find the attachment for sample pipeline and row file which used as input or sample pipeline.

    Regards,
    Ajay
    name.txt (51 Bytes) testCSVHeader_2021_02_03 (1).slp (3.9 KB)