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

    Table convert

    babem

      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

      data_convert.png

        • 1. Re: Table convert
          philmodjunk

          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
            babem

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

            • 3. Re: Table convert
              philmodjunk

              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
                taylorsharpe

                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
                  babem

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

                  • 6. Re: Table convert
                    taylorsharpe

                    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
                      philmodjunk

                      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
                        gofmp15

                        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
                          babem

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

                          data_convert2.png