That sounds good.
I pivoted the data using as JSON, and then used a combo of JSON Splitter/Mapper and Data Validator to validate the data. I still had to hard code some JSON generation scripts, but that was the easy part.
Thanks!
the way we developed, we don’t need to make changes to the snaplogic pipeline if we want to validate different set of files. it could be new set of validation or few new column validation to the same set of files. all we need to do is add validation rule to the table and corresponding file name. its more dynamic validation of data and column name in a file
@fmdf I made a video awhile ago that may help you but it isn’t published yet. I’ll reach out to you directly with the link and work to get it published for the broader audience.
HTTP Response Code (Header) for Triggered Task | SnapLogic - Integration Nation - 13907
