I am attempting to use the modifyrowset function to capture a column within a file, which I will later use as a variable to update a sql statement. However, the file that I am attempting to utilize has a number of different segments / loops which does not allow me to use the modifyrowset function, as when reading the file it is looking for a uniform number of columns to use as an index.
Any assitance in determining how I can read the file, and strip awat a particular row would be appreciated. we are on GoAnywhere Director, Version 4.7.0
What type of file are your reading? Files that are read by GoAnywhere Director need to be data files and would not contain loops, but may contain segments (of sorts) if it is a XML file. Please also post the project XML code from your project.
While in the project, click on SHOW XML then copy & paste the project XML.