2 Replies Latest reply: May 15, 2014 10:01 AM by Grant Perkins RSS

    Moving Fields over Months

    matixsnow1 _

      So I want to trap the YTD amount in each text file, however the YTD column moves to the right in each monthly file.  See below.


      File 1:

      Jan   Feb  Mar  YTD

      1      2    54    57


      File  2: 


      Jan   Feb   Mar  April   YTD

      7     12     10      2     31


      Any ideas on how I can capture the YTD field in each monthly file using the same model?  The numbers are not lining up in this example.



        • Moving Fields over Months
          Data Kruncher

          I have an idea as to how you might overcome this, but need a bit more information.


          Would this report ever contain negative values, and if so, how do they appear? With leading or trailing negative signs, or enclosed in parentheses? And finally, if the negative sign is leading, are there any spaces between it and the value?

            • Moving Fields over Months
              Grant Perkins



              Does a Multi Column Region (MCR) model work with your data?

              Jan, Feb, Mar, YTD would be appended column header values in the way I would define the templates if the report will play ball.


              The idea would be to create a MCR with 12 or 13 columns (13 if your final report has Jan to Dec plus YTD), run that against whatever number of columns the report provides and then filter for YTD in the field that relates to the column heading in an append template.


              If you are familiar with MCR this may make sense. If you are not I may need to expand on the idea a little.