{"id":551,"date":"2021-05-22T12:54:54","date_gmt":"2021-05-22T12:54:54","guid":{"rendered":"https:\/\/support.zippydoc.de\/?p=551"},"modified":"2021-06-15T14:19:22","modified_gmt":"2021-06-15T14:19:22","slug":"unique","status":"publish","type":"post","link":"https:\/\/support.zippydoc.de\/en\/unique\/","title":{"rendered":"Unique"},"content":{"rendered":"

What is the \u2018Unique\u2019 task?<\/strong><\/p>\n

\"\"<\/p>\n

The \u2018Unique\u2019 task can be used to identify all unique entries in a column in a data table. The \u2018Unique\u2019 task can create two tables as output. The first is a table of all first instances of unique entries. The second is table of all other entries. Thus, the \u2018Unique\u2019 task can be used a disassemble a data table into unique and duplicate records.<\/p>\n

 <\/p>\n

 <\/p>\n

How to use the \u2018Unique\u2019 task?<\/strong><\/p>\n

\"\"<\/p>\n

 <\/p>\n

The important fields in the \u2018Unique\u2019 task are<\/p>\n

    \n
  1. Select Table<\/strong><\/li>\n<\/ol>\n

    Use this dropdown menu to select the table from which you would like to identify unique entries.<\/p>\n

     <\/p>\n

      \n
    1. Select Columns to Find Unique Entries From<\/strong><\/li>\n<\/ol>\n

      Use this dropdown menu to select the columns from which you would like to identify unique entries.<\/p>\n

       <\/p>\n

        \n
      1. Output Table Type(s)<\/strong><\/li>\n<\/ol>\n

        Use this dropdown menu to select the output tables you would like to create. You can choose to have an output table of unique entries, or of duplicate entries, or both the tables.<\/p>\n

         <\/p>\n

          \n
        1. Standard Ending<\/strong><\/li>\n<\/ol>\n

          Use this checkbox to indicate if you would like to have standard ending formats for the names of your output tables. The standard endings format for the table of unique entries is \u2018Output Table Name_u\u2019, and that for the table of duplicate entries is \u2018Output Table Name_d\u2019.<\/p>\n

           <\/p>\n

            \n
          1. Unique Output Ending<\/strong><\/li>\n<\/ol>\n

            Use this field to type in and change the standard ending for the name of the table of unique entries.<\/p>\n

            This field becomes visible only if the \u2018Standard Ending\u2019 checkbox is unchecked.<\/p>\n

             <\/p>\n

              \n
            1. Duplicate Output Ending<\/strong><\/li>\n<\/ol>\n

              Use this field to type in and change the standard ending for the name of the table of duplicate entries.<\/p>\n

              This field becomes visible only if the \u2018Standard Ending\u2019 checkbox is unchecked.<\/p>\n

               <\/p>\n

               <\/p>\n

              How to use the \u2018Define Output Table\u2019 and the \u2018Output Options\u2019 sections in the \u2018Unique\u2019 task?<\/strong><\/p>\n

              The \u2018Output Options\u2019 section in the \u2018Unique\u2019 task can be used to modify features of the output table. The fields related to this section become visible on selecting the \u2018Output Options\u2019 checkbox.<\/p>\n

              More information about this section is available here<\/a><\/strong><\/em>.<\/p>\n

               <\/p>\n

               <\/p>\n