W2 reprint from W2 CSV file.

I am trying to find a solution through an IPA to parse W2 csv file with 10,000 recs based on Process Level and Employee number as an input from a primary CSV file using data iterator. I am using two data iterator nodes, one for input and second one to parse and search the W2 record. My issue currently is that when the first record is found, second data iterator node does not resets to first record to start the search over for next record to be searched. Is there any way to reset the data iterator. Any recommendations besides creating a temp SQL table to accomplish this. Does any one have a flow that shows how to use an array feature in IPD. I think if I load the whole file in an array I can avoid reading the file sequentially.

Find more posts tagged with

Process Automation (IPA) - General Discussions

Comments

john-miller

On your second Data iterator - What are you parsing by, and what is your Starting Position to read?

jreese

You shouldn't need to use two separate data iterator nodes to parse the read and parse the records. Send me an email at jreese@communitymedical.org and we can see if options I have used in the past will work for you.

unknown

I am reading by line so second iterator starts from record right after the previous successful record found.

unknown

first iterator read input records from a csv file (Process Level, Employee).

second iterator loops through 10K W2 csv file to find records needed to reprint.

jreese

First thought is can you sort both files so that you do not have to restart from the beginning each time? If you can that will shorten processing time. If you can't, then in the 2nd iterator use a variable for the Starting position to read. Assign 0 to the value before beginning to read the 2nd loop and while in the 2nd loop assign the variable the 2ndNodename_nextPosition.

tewright

When I tried to do the same thing the execution time was huge (hours). I eventually just took the data I was searching on the inner Iterator and shoved it into a string variable. I searched it using an assign node with javascript (indexof or search). It was much faster that way.

Copyright © 2025 Infor. All rights reserved.