0 Replies Latest reply on Dec 8, 2015 8:10 AM by Gene-O 1990

    Compare Table Entries

    Gene-O 1990 Level 1

      Good Morning!

       

      I have created Table1 with two columns: Day and Hours. The user will enter the day of the week they worked, and the number of hours they worked on that day of the week (in no particular order). I need a script that will run Table1 and summarize the entries for me into Table 2.

      TABLE 1

      Day                                   Hours

      Sunday                            8

      Wednesday                     4

      Thursday                         16

      Sunday                            2

      Thursday                         10

       

      TABLE 2

      Sunday                              10

      Wednesday                       4

      Thursday                          26

       

      any ideas?

      I'm using Livecyle Designer ES2 v9

       

      Thanks so much!!

       

      Gene-O