Forum Discussion

sathishmadavali's avatar
sathishmadavali
New Contributor II
3 years ago

How to insert the NULL in place of no data in CSV input fields having no data?

hi team, the input file having csv data with empty rows in some fields, how to insert the NULL in place of no data in the row. thanks
jdbc
slaytanic70's avatar
slaytanic70
New Contributor III
8 years ago
Copy LinkReport

Can the incoming request also send a parameter of “file_type”? Then you could use a router based on this value to handle it as JSON or XML or any other file_type that is sent.

  • endor_force's avatar
    endor_force
    New Contributor III
    2 years ago
    Copy LinkReport

    Hi Rajesh,
    You can probably achieve this in multiple ways. 
    I try to keep it rather clean, using standard snaps, and not nest too much js code in the mappers.

    My sample is first sorting based on employee id and effective date, then it is grouping all records for an employee id in to one.
    Then you can generate the order and the end date individually using javascript map functions and split the employee out again.

    Order = Index +1

    $employee.map((item, index) => ({...item, Order: index + 1}))

     Valid to = If there is another record, fetch its effective date-1, else null.

    $employee.map((item, index) => ({...item, 
ValidTo: 
index+1  == $employee.length ? null : 
Date.parse($employee[index + 1].EffectiveDate)
.minusDays(1)
.toLocaleDateString({"format": "M/d/yyyy"})
}))