Gareth Horton
July 12th, 2002, 01:36 PM
Mike Urbonas wrote:
I do suggest you check into the new "Floating Trap" feature in Monarch V6. This feature allows you to search for a series of trap characters anywhere in each row; that is, the data need not be vertically aligned, and the fields of data automatically adjust depending on where the trap characters are found in each line. This may work to get the data from both of your similarly, but not identically, formatted reports in one Monarch V6 session.
http://www.datawatch.com/pdf/products/monarch/Monarch_v6_upgrade_broch.pdf
> Cbates wrote:
> > I have 2 reports. 1 Report shows me how many customers we have ... For example
> > Bronze level 8260
> > Silver level 2322
> > Gold level 1002
> > Platinum level 270
> >
> > The second report shows me how many customers are free on each of those services.
> > Bronze level 27
> > Silver level 12
> > Gold level 102
> > Platinum level 6
> >
> > When we count our customers, we do not count customers that are free, so my report to management should say we have, for example, 8233 Bronze level customers. Currently I combine this data in Excel. I have not developed a way to open both reports, which would require 2 different models in order to combine them within Monarch, and key on a unique identifier. I would much rather work with the Monarch table and summary views than export to Excel. Is there a way to do that? I am using Standard V6.
>
> If the two reports are not *too* different, it may be possible to build one model that still gets the data out of both reports. Then you could use the FILE function in a calculated field in the Table to determine where each row of data came from. The FILE() command gives you the name of the report file that the data came from.
>
> If you used Monarch V6 Pro, you could export one table from one report to Excel, then open your other report in Monarch, have the data in the Table view, and then do a Join to the Excel file you just created. Then you would have data from both reports in Monarch. Best of all, the table would show one row for each level, with the total customer count and free services count in separate columns, making a calculated field to calc the difference very easy. At the risk of turning this into what might sound like a sales pitch, I honestly think upgrading to V6 Pro for the database joining capability alone is worth it.
>
>
Well, they are not "too" different.. The "Bronze Level", "Gold Level" descriptions in the report are off by 1 space in both reports. I tried to grab an extra space so I would get the whole thing in both reports, then ltrimming and rtrimming (Since in both cases it only grabs an extra space).. But then for some reason I gave up... can't remember what happened... maybe I'll try that method again. I was just hoping it would be easier since there is really a lot more to it than I showed in the post...(Ex. Multiple codes for "Bronze Level".)
I do suggest you check into the new "Floating Trap" feature in Monarch V6. This feature allows you to search for a series of trap characters anywhere in each row; that is, the data need not be vertically aligned, and the fields of data automatically adjust depending on where the trap characters are found in each line. This may work to get the data from both of your similarly, but not identically, formatted reports in one Monarch V6 session.
http://www.datawatch.com/pdf/products/monarch/Monarch_v6_upgrade_broch.pdf
> Cbates wrote:
> > I have 2 reports. 1 Report shows me how many customers we have ... For example
> > Bronze level 8260
> > Silver level 2322
> > Gold level 1002
> > Platinum level 270
> >
> > The second report shows me how many customers are free on each of those services.
> > Bronze level 27
> > Silver level 12
> > Gold level 102
> > Platinum level 6
> >
> > When we count our customers, we do not count customers that are free, so my report to management should say we have, for example, 8233 Bronze level customers. Currently I combine this data in Excel. I have not developed a way to open both reports, which would require 2 different models in order to combine them within Monarch, and key on a unique identifier. I would much rather work with the Monarch table and summary views than export to Excel. Is there a way to do that? I am using Standard V6.
>
> If the two reports are not *too* different, it may be possible to build one model that still gets the data out of both reports. Then you could use the FILE function in a calculated field in the Table to determine where each row of data came from. The FILE() command gives you the name of the report file that the data came from.
>
> If you used Monarch V6 Pro, you could export one table from one report to Excel, then open your other report in Monarch, have the data in the Table view, and then do a Join to the Excel file you just created. Then you would have data from both reports in Monarch. Best of all, the table would show one row for each level, with the total customer count and free services count in separate columns, making a calculated field to calc the difference very easy. At the risk of turning this into what might sound like a sales pitch, I honestly think upgrading to V6 Pro for the database joining capability alone is worth it.
>
>
Well, they are not "too" different.. The "Bronze Level", "Gold Level" descriptions in the report are off by 1 space in both reports. I tried to grab an extra space so I would get the whole thing in both reports, then ltrimming and rtrimming (Since in both cases it only grabs an extra space).. But then for some reason I gave up... can't remember what happened... maybe I'll try that method again. I was just hoping it would be easier since there is really a lot more to it than I showed in the post...(Ex. Multiple codes for "Bronze Level".)