Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

exporting a One-To-Many Set to Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    exporting a One-To-Many Set to Excel

    Good morning to all:

    I am using Alpha5V11 Desktop. I am trying to export a one-to-many set to Excel by unique parcel numbers, which contains approximately 400 records. However, when I review the results in excel, I see that each record was duplicated 4 times.

    Is there a simple method of exporting these records so that the there is one original record exported, and not any additional duplication's? I previously tried by Creating A New Operation; Export Records (using the Genie), and got hung up with the final results. I believe I am missing something in between to remove the duplication's?

    Can someone assist me with a simple instructions of how I can eliminate the records duplication's.

    thank you for your assistance.

    Howie

    #2
    Re: exporting a One-To-Many Set to Excel

    Have you looked at creating a mapped table from your set? You could then use that virtual table to export to Excel.
    Robin

    Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

    Comment


      #3
      Re: exporting a One-To-Many Set to Excel

      Good morning, Robin:

      Thank you for responding. I am not too good with computers. I am not sure what a mapped table is. In the past, I was able to use the Genie to export my set, but I cannot find my old notes. Is there any notes on a mapped table I can read up on.

      Regards,

      Howie

      Comment


        #4
        Re: exporting a One-To-Many Set to Excel

        Hi Howie,
        The first place to look is in the Wiki mapped tables.

        Edit: Actually that may not be what you want as it only links your tables one on one. Let me think about it some more...
        Robin

        Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

        Comment


          #5
          Re: exporting a One-To-Many Set to Excel

          xls_export.jpg

          Notice in my sample export above, that what looks like 4 duplicates is actually 4 unique records because of the YARN_KEY field. Perhaps you are not exporting the field from your table that would show it is a unique record in your spreadsheet?
          Robin

          Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

          Comment


            #6
            Re: exporting a One-To-Many Set to Excel

            Hi Robin:

            Thank you for your response. I tried to create a New Operation & use the "unique" key I "got lost" in trying to figure out how to use the rest of the options and functions. Can you you show me a sample of the steps and options you used in your above export. Maybe I can try and duplicate your method.

            Again, thank you for your input.

            Regards,

            Howie

            Comment


              #7
              Re: exporting a One-To-Many Set to Excel

              Howie,
              Better yet, why not give us a sampling of the tables in your set? That is usually how it works in here. Then you can show us exactly what you want to export, and my example with your data will make much better sense for what you want the export to do.
              Robin

              Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

              Comment


                #8
                Re: exporting a One-To-Many Set to Excel

                Logically

                If there is a master record with one to many that has 4 child records attached ...
                Exporting OR copying to flatten that master record that INCLUDES ANY child fields, WILL create 4 records - reason, there are 4 child records that are individuals and may or may not be unique - however the export will not arbitrarily select one of the children only. How would you accurately suggest to represent that?

                Either do not include child fields OR make a set that connects 1 to 1 to a selected child ie. first or last or biggest field value ...

                Comment


                  #9
                  Re: exporting a One-To-Many Set to Excel

                  can you "flip" the set? By flip, I mean to make the child the parent and the parent the child. link 1 to 1 and then export. Select only the fields you absolutely need from each record. there shouldn't be any duplicates.

                  Comment


                    #10
                    Re: exporting a One-To-Many Set to Excel

                    That will produce exactly the same duplicates of the master records...

                    Comment


                      #11
                      Re: exporting a One-To-Many Set to Excel

                      Since we haven't seen Howie's data, I can only guess that if he wants only one record with a unique parcel number from the child table that he first needs to create a temporary table and copy only the first matching record to it then send that table to Excel.
                      Robin

                      Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

                      Comment


                        #12
                        Re: exporting a One-To-Many Set to Excel

                        and the mapped table you suggested in post #4 Robin was not such a wrong suggestion, could well do that too.
                        Appears Howie has left the building anyway

                        Comment


                          #13
                          Re: exporting a One-To-Many Set to Excel

                          Originally posted by MoGrace View Post
                          Since we haven't seen Howie's data, I can only guess that if he wants only one record with a unique parcel number from the child table that he first needs to create a temporary table and copy only the first matching record to it then send that table to Excel.

                          Comment


                            #14
                            Re: exporting a One-To-Many Set to Excel

                            Hi MoGrace:

                            Attached is some sample data. Sorry for the delay, I just got back to my office. When I try and export a one-to-many to Alpha, I get many duplicates records, which I cannot seem to correct. I am not good on computers. Please let me know if you did not receive my attachment.

                            Regards,

                            Howie1
                            Attached Files

                            Comment


                              #15
                              Re: exporting a One-To-Many Set to Excel

                              Howie,
                              I looked at your tables and you have more than one Owner ID for the same name and address, whereas the Legal desc is a unique identifier. So perhaps you should change the set to have Legal as the header which would then be linked 1:1 to the Owner which in turn is linked 1:1 to the address and 1:n to the the other tables if they are dependent on the owner otherwise link them to the parcel. It looks like the bal_owed field is actually related to the parcel which in turn is related to the owner.

                              I would also eliminate the duplicate owners since you only need one owner id to link to more than one parcel. And perhaps combine the Expired and Last Contacted tables which appear to have the same data.

                              Legal
                              ->Owner
                              -->Address
                              ==>Contacted
                              ==>Expired
                              Robin

                              Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

                              Comment

                              Working...
                              X