I am trying to parse Large Flat file. I am using convertToValues in REPEAT loop to parse the file. I understand that I need to EXIT the repeat when ffIterator variable is null. I am not able to set this condition.
Can someone help me how to check ffIterator for null and then EXIT the repeat.
You don’t need to explicitly set ffIterator. After your pub.flatFile:convertToValues, set up a BRANCH on ffIterator. Underneath the BRANCH, put in an EXIT with (Label = $null), (Exit from = $loop), and (Signal = SUCCESS).
Make sure your REPEAT is set to Repeat On Success with a count of blank or -1 and your convertToValues has iterate set to “true.”
I am doing exactly same what you have suggested. But in this way, I am missing to process last record of the file as it is exiting from the flow as ffIterator comes null when convertToValues pull last record of the file. How should I fix it? Please suggest.