- This topic has 2 replies, 2 voices, and was last updated 6 years, 2 months ago by
.
-
Topic
-
Hi Folks, 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?
-
Replies
-
-
If all is configured properly, you would use a segment ITERATE not a List ITERATE.
The Xlate will know when you have run out of repetitions.
If you would like some personal assistance, email me. My email is on my signature.
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
-
-
- The forum ‘Cloverleaf’ is closed to new topics and replies.
