AnsweredAssumed Answered

Consolidating multiple records with few fields into a single record with multiple fields?

Question asked by ALB on Mar 16, 2013
Latest reply on Apr 2, 2013 by philmodjunk

Title

Consolidating multiple records with few fields into a single record with multiple fields?

Post

      

     I’m using Filemaker Pro version 11.0v4, and I’m trying to do something that I think should be simple, but I just can’t figure it out.

     I am importing data from Excel into an existing FileMaker database, and the structure of the data in the Excel file is not the way I would like my FileMaker table to be structured. In my imported file, each imported data point is in its own row, and I would like my Filemaker table to have multiple data points per record. For example,

     Imported:

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
                    

                         Student ID

               
                    

                         Judge number

               
                    

                         Grade

               
                    

                         1

               
                    

                         1

               
                    

                         77

               
                    

                         1

               
                    

                         2

               
                    

                         70

               
                    

                         1

               
                    

                         3

               
                    

                         82

               
                    

                         2

               
                    

                         1

               
                    

                         85

               
                    

                         2

               
                    

                         2

               
                    

                         80

               
                    

                         2

               
                    

                         3

               
                    

                         87

               
      

      

     Desired:

                                                                                                                                                                                                                                                                             
                    

                         Student ID

               
                    

                         Grade Judge 1

               
                    

                         Grade Judge 2

               
                    

                         Grade Judge 3

               
                    

                         1

               
                    

                         77

               
                    

                         70

               
                    

                         82

               
                    

                         2

               
                    

                         85

               
                    

                         80

               
                    

                         87

               
      

      

     I have currently set up a child table to contain the imported data, and then I am trying to relate a parent table to consolidate the data. I want to use the “Judge number” field of the child table to assign which of three fields to populate in the parent table, using the contents of the “Grade” child field. Is there a way I can define the three fields in the parent table as calculation fields so that this happens dynamically as soon as I import data into the child table?

      

Outcomes