DSweet Posted June 26, 2019 Share Posted June 26, 2019 Hello, Starting with multi-line files. I get the concept of the multi-line record and how to go through it with GetMultiLineRecords() to iterate through the collected records for each set, however how am I able to "pre-count" the total "collected sets" of the multi-line data file? As an example I have a data file with 12 lines, and the file is defined in FusionPro as multi-line when an account number changes. There are three account changes in the file so FusionPro SHOULD tell me that there are 3 records in this file. When I open the preview window the number at the bottom states 3 ... as in three records. However if I do either a ".totalRecordCount" or ".recordCount" on the input file name FusionPro will return the value of 12. I know that there are twelve LINES of data in the file, but since it is defined as a multi-line data file and FusionPro is already telling me in the preview window that it recognizes only three records shouldn't either of those functions return a value of 3? How do I get this value in the beginning of a job process? . Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.