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...
viktor_n's avatar
viktor_n
Contributor II
5 years ago

Hi @acesario,

Hope this will solve your problem.

Expression:
$Records.map(record => record.Award.map((x, index) => record.Award.slice(0, index + 1).filter(y => y == x).length))

Output:

  • Ajay_Chawda's avatar
    Ajay_Chawda
    Contributor
    5 years ago

    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)