Guys,
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.
How much large is your flatfile?
Since i have parsed 28-30MB with out any problems using wm.flatfile:convertToValues,i didnt set ffIterator param at all.
Just schedule the service or directly run the service with out step thru.
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.