I have a request heading my way that I am not sure is achievable. However I am new to WebFocus and am hoping that something may exist to help me out!
We have 2 identically structured files. The first file contains information of a primary stock count, and is keyed by product. The 2nd file contains many records per product and relates to the 2nd, 3rd, 4th etc stock counts.
So what they are looking for is something like this:
So only data from File A to be on row 1 and the following rows to contain data from File B.
The way I would expect the report to work with my current WebFocus experience would be
But this is not what is wanted!!
Having a think about it, the best solution I can think of is to enquire FileA with the product and output the record structure to a work file. Then to enquire FileB with the product, append the resulting record structure to the work file and finally to run the report over the work file. Can I append to a file in WebFocus?
Well, I hope you guys can understand my jabbering and perhaps I have answered my own question, but any input would be gratefully received!!
WebFocus 765. iSeries v5r4