Forum Discussion

Sgarim4's avatar
Sgarim4
New Contributor II
7 years ago
Solved

Date Filter for loading Excel File

I am trying to filter an excel file from a folder based on date to load onto a database. I have successfully managed to get the filter snap to filter out all months other than current month with the ...
  • del's avatar
    del
    5 years ago

    The Array.reduce function appears to be effective for this:

    shortened syntax:

    $myArray.reduce((av,cv,ci,ar) => (av && (ar[0] == cv)), true)

    or verbose syntax:

    $myArray.reduce((accumulatedValue,currentValue,currentIndex,originalArray) => (accumulatedValue && (originalArray[0] == currentValue)), true)

siwadon's avatar
siwadon
Employee
5 years ago
Copy LinkReport

Is it SFTP or SMB protocol? Can you please provide the stacktrace?

You mentioned that the validation was fine. Was the execution mode of File Writer set to Validate & Execute?

  • neelamanikandan's avatar
    neelamanikandan
    New Contributor II
    3 years ago
    Copy LinkReport

    Hi RogerSramkoski  It was a question, in the above example I had 2 (Servicecompany and Servicecompanydetail) fields that had values in array, so I have used 2 JSON splitters in the pipeline. But if my input JSON contains multiple(eg. 10) array fields should I always use multiple (10 JSON splitters) in the pipeline? Is there alternate Snap that can flatten all the Array elements at one go, or is there an alternative approach to use the JSON splitter to flatten all arrays