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 ...
  • rpatrick00's avatar
    5 years ago

    Yeah, I finally realized that Join snap cannot handle joining fields into same top-level structure so I eliminated the top level structure for the join, and then used a mapper to add the top-level structure back. I had to write a custom snap (not included) to prune off all the null fields/elements created by the Null Safe Access mappers…

    I must say that was a lot more painful than I think it should be. If I were to use this in an actual business process, the logic of the business process flow would get lost due to this complex mapping flow…

    Here is the final working example (with all of the nulls still present).

    Mapping Conundrum_2020_09_30 (3).slp (56.6 KB)

    Thanks for the help,
    Robert