2 Replies Latest reply: May 15, 2014 10:14 AM by ebp913 _ RSS

    Multiple rows not being captured by table

    ebp913 _

      I have some data in a CSV that is a mapping of reclasses in a cost accounting system and my end goal is this

      Type             Name             From    To              Month 1     Month 2, etc

      Expense     CMC 103,     8740       6010     1.16%     1.38%

       

      I am having issues because Monarch is only displaying one of the from accounts in my CSV even though my trap is capturing all the from accounts.  Basically my file has some reclasses where there could be 1 "from" account or there could 10 "from" accounts.  My table is only showing the last "from" in each reclass and none of the ones above it. 

       

      This is an ugly version of what the data looks like

       

      Reclass     Name     Reclass     CMC 103     Description     1200 Reclass School of Nursing 8000s                                        

      Account Type     1     Account Type     Expense                                                  

      Reclass Type     3     Reclass Type     Reclass     Source     Both G/L and Payroll     Sequence     451                              

      Method     3     From Method     Percent     To Method     Statistic     Statistic     1200 TOTAL FTE STATIC 1200 Total FTE Static Stats                              

      From     1     From Accounts                                                       

      From CC     3     1200 Covenant Medical Center     8220[/U] School of Nursing     E Expense                                             

      From CC     3     1200 Covenant Medical Center     8658[/U] Health Traxx     E Expense                                             

      From CC     3     1200 Covenant Medical Center     8720[/U] Nursing Admin     E Expense                                             

      From CC     3     1200 Covenant Medical Center     8724 /UNursing Orient/Education     E Expense                                             

      From CC     3     1200 Covenant Medical Center     8726 /UDischarge Unit-Nursing     E Expense                                             

      From CC     3     1200 Covenant Medical Center     8730[/U] Staffing Office-Nrsg     E Expense                                             

      From CC     3     1200 Covenant Medical Center     8740[/U] Inservice Educ     E Expense                                             

      To     1     To Accounts                                                       

      To CC     5     1200 Covenant Medical Center     6010 /IICU     E Expense                                             

      To %     12     1.16%     1.38%     1.11%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%

      To CC     5     1200 Covenant Medical Center     6011 /ISICU-S2     E Expense                                             

      To %     12     5.98%     6.48%     5.78%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%

      To CC     5     1200 Covenant Medical Center     6012 /IMICU-S3     E Expense                                             

      To %     12     3.81%     3.29%     3.93%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%     0.00%

       

       

      The end goal is that my table shows each underlined "from" account with all the italicized "to" accounts and their corresponding percents.  So it should look like this:

      From    To       Month 1  Month 2, etc

      8220    6010 

      8220    6011

      8220    6012

      8658    6010

      8658    6011

       

      As I said earlier, the only "from" account that shows up is the last one listed in the reclass so in this case it would be 8740.  Any help would be much appreciated!