10 Replies Latest reply: Mar 30, 2017 9:16 AM by Stephen Smay RSS

    Unable to Append in Monarch DPS v13.5

    David Rubin

      Hey everyone,

       

      I have a Microsoft Access database that has two tables that are identical, but the only difference between the two of them is one table is used for current, relevant data, and the other is used for archive data.  However, once again, both tables are structured identically, but unfortunately, DPS does not acknowledge they could be appended into one table.  Has anyone else experience this type of issue with this type of data, and/or does anyone have a work around for it?

        • Re: Unable to Append in Monarch DPS v13.5
          Grant Perkins

          David,

           

          What are you doing in order to join the tables?

           

          How are you approaching the requirement?

           

           

          Grant

            • Re: Unable to Append in Monarch DPS v13.5
              David Rubin

              I am not attempting to do a join, but instead, I am trying to do an append, where the data is added to the existing columns of a current table with the same structure.  However, the append option is not available, although the tables are identical (one is simply an archived/housing area for completed work while the other collects the data to be analyzed that will later need to be appended/moved [for lack of a better term] into the archive).  I was hoping to do perform the action quickly in Data Prep Studio (DPS).  I am currently using version 13.2.

            • Re: Unable to Append in Monarch DPS v13.5
              Steve Caiels

              Hi David,

               

              It would be good to get to the root cause, but as a workaround, you should be able to append them in the "Prep Data" window.  Hit Ctrl-A to select all tables (or the normal Windows ctrl-Click) if you have other tables, then right click on a table and choose an append operation.

               

              Append Tables->Strict Append should work fine if the table structures are identical in Data Prep.  If not, the Append Helper should guide you through the process.  It might also help to show why Data Prep is not happy to append them from the Preview Data windows.

               

              I did see some issues where the "Append" button didn't seem to keep up to date with the table selections in the earlier versions of Data Prep Studio.  Have you tried 'clearing' and re selecting the tables in the preview window?  If you have an opportunity to upgrade to 14, it would be worthwhile I believe.  in fact, 14.1 is due to be released imminently with major enhancements to the change list.

               

              Regards,

              Steve.

              • Re: Unable to Append in Monarch DPS v13.5
                David Rubin

                Correction: I am using version 13.2 if that provides any further insight.

                • Re: Unable to Append in Monarch DPS v13.5
                  David Rubin

                  Hey everyone,

                   

                  I appreciate the insight from everyone, and I have attached two images below to show everyone what I am experiencing.  Although it may be harder to see, the second image illustrates the gray out of any append option.  Once again, the structure of both tables are identical, but DPS is not identifying it as such, which is preventing me from appending the tables together.  Any help is appreciated.

                   

                  Add Data Screen Append Fail.jpgPrep Data Append Fail.jpg

                    • Re: Unable to Append in Monarch DPS v13.5
                      Stephen Smay

                      Ah! You said you're using 13.2... this was before we developed the "Smart Append" abilities (which includes Append Helper).

                       

                      From that version, the best advice I would give is to triple check that the columns on both tables are (1) named exactly the same, (2) in the exact same order, and (3) all the exact same data type.