9 Replies Latest reply on Jul 14, 2017 11:44 PM by babem

    Table convert


      I would like to convert my datatable to a new table, but I don't know how to do.

      Can help somebody me pls.

      Here is my sample tables


        • 1. Re: Table convert

          Why a new table?


          I can see that you want one record for each unique value and a horizontal list of filenames delimitted by commas, but why create a new table to get this result?

          • 2. Re: Table convert

            I don't want to create a new table, but I do not know how to make a query.

            • 3. Re: Table convert

              And what will you do with the results? This is not a trivial question as you can produce the desired results in a number of different formats from a summary report, the results all in one field to a portal or a list view.....

              • 4. Re: Table convert

                Just Click the "Find" button at the top and type in your request and hit "Perform Find" and you'll see the found set of your table.  You don't have to create a new table for the result. 

                • 5. Re: Table convert

                  I need this form of table, because i want to export this result to an excel file

                  • 6. Re: Table convert

                    Just do a Find above and export the found set.  Don't create a new table.  FileMaker Exports only export what is displaying in the found set. 

                    • 7. Re: Table convert

                      First find the records you want. In this example that would be show all records to get all the records in your table. Then sort them by the first field to group them.


                      If you define a "list of" summary field it can be set to list the contents of the second field. If you then use export records with the "group by" option, you can get one row of data for each unique value. If you include the summary field, it should list all of the file names, but separated by returns.


                      To get commas will require the get summary and substitute functions.

                      • 8. Re: Table convert

                        You can create a 'table' by creating a self join on your data table based on the field sku. Drag the line outward from sku and then back in on itself and let go. FileMaker will note this and offer to create a duplicate of the table.


                        Once you have this related self-join table you can use it in a portal and also use the 2nd table to create a report etc. and also export to excel from it, etc.

                        • 9. Re: Table convert

                          Ok, thanx your idea, I did it. Now, what's next? Please a sample, I'm a beginner in Filemaker.