I get a file every day. It will not have a static number of rows. On any given day it could have between 5 and 2000 rows in it… maybe more. Each row has 10 columns, pipe-delimited. I went with a HRL of VRLs for the confguration, meaning it will be a HRL that could repeat any number of times, with each record consisting of 10 fields (the VRL).
To process the file, which I’m turning into an X12 856, I have to iterate through each HRL row and build the segments. Again, each HRL row is a VRL with 10 fields. I hope my question isn’t too confusing, but I can’t figure out how to set the basis to iterate through the HRL list until nothing is found? I obviously can’t set the list iterate basis as 0 1 2 3 4 5 6 7 … 2000, so is there an easy, clean way to have an iterate keep going until it hits a null for the HRL?