Solved

*MONARCH V.7* Very complicated text file report that needs to be moved to Excel

Posted on 2008-10-29
2
798 Views
Last Modified: 2013-12-12
I have never really used Monarch, but I have read and completed the associated tutorial and understand how the program works.  I have the ugliest report known to mankind and cannot find a way to get it into Excel.  I can get very close with my model, but cannot reach an end.

I have a multi level report (attached) in which I need the general headers that you will see (Purchase order #, Shop Order #, Model etc). I also need the "header info" for the following:  "for ship to code", "order id", and "order desc".

The problems arise when you see items like PO: EI-08046/MKH.  If you notice the line directly below looks more relevent (with the Shop Order) than the line above it (except I need the PO #).  There is no Quantity (req, prom or ship) data on the first line.  I would like to compress these into one with the relevent data.

Other problems arise when you see PO number LG0801.  1st and 2nd lines have the same issue as above, but the 3rd, 4th, 5thand 6th now have relevent shipping and promise dates.  I want each of these lines, but with the relevent data attached (PO, SO, Model #).  

To further complicate, in PO number 8100018088, you see that all the relevent data is on the first line.

If it would be easier leave the items I called "header info" above off and run a seperate report for these that will also bring in the SO# (or other "primary key"), so I can reference this data....that would work as well.  

I hope this isn't too confusing, but I cannot find a way to do this.  I REALLY REALLY appreciate any help given!

Thanks in advance
EE-Example.txt
0
Comment
Question by:MAC050
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Expert Comment

by:doser
ID: 22954445
Can you attach a copy of your model?  I want to see what your templates look like?
0
 
LVL 18

Accepted Solution

by:
jmoss111 earned 500 total points
ID: 23493675
Hi MAC050,

I may try to build a model for this but I'm using v9 and I don't think v9 will build .mod files, but only .xmod files and I have no idea where my Monarch 6 cd is which I think that v7 could read.

That file is nowhere near the ugliest file known to man; a little challenging maybe.

Regards,

Jim
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question