{"id":84787,"date":"2020-02-26T12:03:17","date_gmt":"2020-02-26T03:03:17","guid":{"rendered":"https:\/\/support.questetra.com\/?p=84787"},"modified":"2021-07-06T11:50:55","modified_gmt":"2021-07-06T02:50:55","slug":"table-duplicate","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/table-duplicate\/","title":{"rendered":"Table, Duplicate"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5e54c;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFFF66;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3><i class=\"fal fa-exclamation-circle\"><\/i> PAGE UPDATED<\/h3>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/table-duplicate-2021\/_\">https:\/\/support.questetra.com\/addons\/table-duplicate-2021\/<\/a><\/div>\n<\/div><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Table, Duplicate<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\">\n\n\n\n<p class=\"wp-block-paragraph\">Duplicates Table-type data. All cell value stored in Table-type data A is copied over Table-type data B. If the table column definitions are different, an error may occur.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">2020-02-25 (C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/table-duplicate\/\">https:\/\/support.questetra.com\/addons\/table-duplicate\/<\/a><\/p>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> A: Select TABLE DATA<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> B: Select TABLE DATA (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> B2: Select TABLE DATA (append)<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ Notes:\n\/\/ Copies text information of all cell values.\n\/\/ Copies in the display order of the column. (Does not refer to column ID)\n\/\/ If the number of columns decreases, the right columns will not be copied.\n\/\/ If the number of columns increases, blank strings will be completed.\n\/\/ To re-order columns, consider Table-TsvString-TsvEdit-Table.\n\/\/ Auto-calculated columns are reevaluated. (Not always the same value)\n\/\/ Use the standard function for duplication of string, numeric, date, etc.\n\/\/ - Automated Step (BPMN Icons): \"Service Task (Data Assignment)\"\n\/\/ - M227: Auto Executing Data Binding, Arithmetic Operations\n\/\/ To add data without erasing already stored cell data, use B2.\n\/\/\n\/\/ Notes (ja):\n\/\/ \u5168\u3066\u306e\u30bb\u30eb\u5024\u306e\u6587\u5b57\u60c5\u5831\u3092\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002\n\/\/ \u30ab\u30e9\u30e0\u306e\u8868\u793a\u9806\u306b\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002\uff08\u30ab\u30e9\u30e0ID\u306b\u95a2\u308f\u3089\u306a\u3044\uff09\n\/\/ \u30ab\u30e9\u30e0\u5217\u6570\u304c\u5c11\u306a\u304f\u306a\u308b\u5834\u5408\u306f\u3001\u53f3\u5217\u90e8\u304c\u30ab\u30c3\u30c8\u3055\u308c\u307e\u3059\u3002\n\/\/ \u30ab\u30e9\u30e0\u5217\u6570\u304c\u5897\u3048\u308b\u5834\u5408\u306f\u3001\u7a7a\u767d\u6587\u5b57\u5217\u3067\u88dc\u5b8c\u3055\u308c\u307e\u3059\u3002\n\/\/ \u5217\u306e\u5165\u308c\u63db\u3048\u306f\u3001Table\u2192TSV\u6587\u5b57\u5217\u2192TSV\u52a0\u5de5\u2192Table\u7b49\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n\/\/ \u81ea\u52d5\u8a08\u7b97\u30ab\u30e9\u30e0\u306f\u3001\u518d\u8a55\u4fa1\u3055\u308c\u307e\u3059\u3002\uff08\u5fc5\u305a\u3057\u3082\u540c\u3058\u5024\u306b\u306a\u308a\u307e\u305b\u3093\uff09\n\/\/ \u6587\u5b57\u5217\u578b\u30fb\u6570\u5024\u578b\u30fb\u65e5\u4ed8\u578b\u306a\u3069\u306e\u30c7\u30fc\u30bf\u8907\u88fd\u306b\u306f\u3001\u6a19\u6e96\u6a5f\u80fd\u3092\u3054\u6d3b\u7528\u304f\u3060\u3055\u3044\u3002\n\/\/ - \u81ea\u52d5\u51e6\u7406\u5de5\u7a0b(BPMN\u30a2\u30a4\u30b3\u30f3): \uff3b\u30b5\u30fc\u30d3\u30b9\u30bf\u30b9\u30af\uff08\u30c7\u30fc\u30bf\u8a2d\u5b9a\uff09\uff3d\n\/\/ - M227: \u696d\u52d9\u30c7\u30fc\u30bf\u306e\u7d50\u5408\u3084\u56db\u5247\u6f14\u7b97\u304c\u81ea\u52d5\u5b9f\u884c\u3055\u308c\u308b\u3088\u3046\u306b\u8a2d\u5b9a\u3059\u308b\n\/\/ \u65e2\u306b\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\u30c7\u30fc\u30bf\u3092\u6d88\u3055\u305a\u306b\u8ffd\u8a18\u3057\u305f\u3044\u5834\u5408\u306f\u3001B2\u3092\u3054\u5229\u7528\u304f\u3060\u3055\u3044\u3002\n\n\n\/\/\/\/\/\/\/\/ START \"main()\" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){\n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst dataIdA  = configs.get( \"conf_DataIdA\" )  + \"\"; \/\/ required\nconst dataIdB  = configs.get( \"conf_DataIdB\" )  + \"\"; \/\/ not required\nconst dataIdB2 = configs.get( \"conf_DataIdB2\" ) + \"\"; \/\/ not required\n\/\/ 'java.lang.String' to javascript primitive 'string'\n\nlet numColsA  = 0;\nnumColsA  = engine.findDataDefinitionByNumber( dataIdA )\n                  .getSubDataDefinitions().size() - 0;\n\/\/ com.questetra.bpms.core.event.scripttask.ProcessDataDefinitionView\nengine.log( \" AutomatedTask TableConfig:\" +\n            \" #of {A}-Columns Definition: \" + numColsA );\nlet numColsB  = 0;\nif( dataIdB !== \"\" ){\n  numColsB  = engine.findDataDefinitionByNumber( dataIdB )\n                    .getSubDataDefinitions().size() - 0;\n  engine.log( \" AutomatedTask TableConfig:\" +\n              \" #of {B}-Columns Definition: \" + numColsB );\n}\nlet numColsB2  = 0;\nif( dataIdB2 !== \"\" ){\n  numColsB2 = engine.findDataDefinitionByNumber( dataIdB2 )\n                    .getSubDataDefinitions().size() - 0;\n  engine.log( \" AutomatedTask TableConfig:\" +\n              \" #of {B2}-Columns Definition: \" + numColsB2 );\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nconst inputTable = engine.findDataByNumber( dataIdA ); \n\/\/ com.questetra.bpms.core.model.formdata.ListArray (BPMS Table)\n\/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300\nif( inputTable === null ){\n  throw new Error( \"\\n AutomatedTask UnexpectedTableError:\" + \n                   \" Table {A} is empty \\n\" );\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet outputTable1 = new com.questetra.bpms.core.model.formdata.ListArray();\nif( dataIdB !== \"\" ){\n  for( let i = 0; i &lt; inputTable.size() - 0; i++ ){\n    let tmpRow = new com.questetra.bpms.core.model.formdata.ListArray.ListRow();\n    if( numColsA &lt; numColsB ){\n      for( let j = 0; j &lt; numColsA; j++ ){\n        tmpRow.addCol( inputTable.getRow(i).getCol(j) );\n      }\n      for( let j = 0; j &lt; numColsB - numColsA; j++ ){\n        tmpRow.addCol( \"\" ); \/\/ Fill with empty characters\n      }\n    }\n    if( numColsA &gt;= numColsB ){\n      for( let j = 0; j &lt; numColsB; j++ ){\n        tmpRow.addCol( inputTable.getRow(i).getCol(j) );\n      }\n    }\n    outputTable1.addRow( tmpRow );\n    engine.log( \" AutomatedTask:\" +\n                \" Add B&#091;\" + i + \"]\" );\n  }\n}\n\nlet outputTable2 = new com.questetra.bpms.core.model.formdata.ListArray();\nlet numOriginLines = 0;\nif( dataIdB2 !== \"\" ){\n  if( engine.findDataByNumber( dataIdB2 ) !== null ){\n    outputTable2 = engine.findDataByNumber( dataIdB2 ); \n    numOriginLines = engine.findDataByNumber( dataIdB2 ).size() - 0;\n  }\n  engine.log( \" AutomatedTask:\" +\n              \" #of {B2}-Rows: \" + numOriginLines );\n\n  for( let i = 0; i &lt; inputTable.size() - 0; i++ ){\n    let tmpRow = new com.questetra.bpms.core.model.formdata.ListArray.ListRow();\n    if( numColsA &lt; numColsB2 ){\n      for( let j = 0; j &lt; numColsA; j++ ){\n        tmpRow.addCol( inputTable.getRow(i).getCol(j) );\n      }\n      for( let j = 0; j &lt; numColsB2 - numColsA; j++ ){\n        tmpRow.addCol( \"\" ); \/\/ Fill with empty characters\n      }\n    }\n    if( numColsA &gt;= numColsB2 ){\n      for( let j = 0; j &lt; numColsB2; j++ ){\n        tmpRow.addCol( inputTable.getRow(i).getCol(j) );\n      }\n    }\n    outputTable2.addRow( tmpRow );\n    engine.log( \" AutomatedTask:\" +\n                \" Add B2&#091;\" + (numOriginLines + i) + \"]\" );\n  }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( dataIdB !== \"\" ){\n  engine.setDataByNumber( dataIdB, outputTable1 );\n}\nif( dataIdB2 !== \"\" ){\n  engine.setDataByNumber( dataIdB2, outputTable2 );\n}\n\n\n} \/\/\/\/\/\/\/\/ END \"main()\" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/code><\/pre>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img decoding=\"async\" src=\"data:image;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADCUlEQVRYR82XT0iTcRjHP6\/ONV2i\nK7EQYaFCoHZQuugh1MRjh6BJUQfrsJkXg6CTHrwFYZ5yghVo5iHoFl6EQtRTJBaCmOBEQ0XM0s2J\n+\/PG713v3F73zm1ob7\/j8z7P9\/m+z9\/fT8LgI6Xsf4A8ZG4i0YhMDRKXANtf+21kPEjMIPMRifc4\n2UsF+3gCr7nIAU8AF2BJBRTYB9yYeUob68lskhNw40LiGWBN0bFWzYfMY1y49ez1CQzwAmjP0LHW\nrB8nDxNhJSbg5i0St0\/IeQRGZhQXd7SYRwmc7J8fG4l4ApGc9wur\/Jx8WkpbyDPlZRSIQDjA5Pok\nq77VeHuZ9tiaOCQQqfZFteBGr4\/SWt6KxPGNosdwdmsWx7iDhd8LsSo+zFSo3XGIPsBzoFPVnLs1\nR6WtMqO\/V412A7t0THYw\/H1Yi9OHk0dCGCEghgxsxfa5IFBkKWL8xzghOaSo2c\/aqb9Qz\/TGNMve\nZUUmUiRStenfZGpjKuqo2lZNRUGFHgExJ86LYRUh4OYuEnE0BQFxqt5VRUF7rvbQeaWTvm99dH\/u\nVuRNJU0MNQ4x\/2ue5g\/NUd3Ba4M4yh16BERX3MPFGzUCL4H7sXE6dQLwCicP1Ah8QaJGS+By4WX8\nQT8ysvLJJJnINeUqsqAcVGRZUpaShlA4hD\/kj0KYs8wchA+SRWAGF7VqBH7GLBYFRESg1FqKx+uJ\nghaYCyKyXQ++oE+RZ0vZlOWX4Q16Wdtbi+razDYKzxTqE4BtnJxTCUR+Meb8gxSAE+m\/IZAwBYlq\nwGKyKDWgtqYYVKIuZFlOrwbiUuAmYRHa8+0s7SwRJqwkJ1kN7If2WfGtRJNYbCnGmmNNuQgNb0PD\nB9GRUTxxY4K64rq4vIo5oFcDwXBQ6Xv1CN2dwA5tn9oYWxnTNplmFIvPmmXUUNJAV22Xsg8yOYLQ\nyOIIvV97E5lrlpFQ0azjTJymaKOzjoV1zIUkRbD01XQvJCqUoVcylYShl9LTiUSa1\/LDSBj4MFFJ\nGPo0i61xwx6n6TdaWhZ\/ADmdsjBbatgaAAAAAElFTkSuQmCC\" alt=\"\"\/><\/figure><\/div>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/a\/questetra.com\/file\/d\/1-n5WvzFHfhFjwpRuBiCyCqiPT3shaH5E\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Table-Duplicate.xml (opens in a new tab)\">Table-Duplicate.xml<\/a><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/table-duplicate.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"84791\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/table-duplicate\/attachment\/table-duplicate-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Table-Duplicate-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i1.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-capture-en.png?fit=1024%2C576&amp;ssl=1\" alt=\"Duplicates Table-type data. All cell value stored in Table-type data A is copied over Table-type data B. If the table column definitions are different, an error may occur.\" class=\"wp-image-84791\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Copies text information of all cell values.<\/li><li>Copies in the display order of the column. (Does not refer to column ID)<\/li><li>If the number of columns decreases, the right columns will not be copied.<\/li><li>If the number of columns increases, blank strings will be completed.<\/li><li>To re-order columns, consider Table-TsvString-TsvEdit-Table.<\/li><li>Auto-calculated columns are reevaluated. (Not always the same value)<\/li><li>Use the standard function for duplication of string, numeric, date, etc.<ol><li>Automated Step (BPMN Icons): <a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-data-assignment\/\">&#8220;Service Task (Data Assignment)&#8221;<\/a><\/li><li>M227: <a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002260571-M227-Auto-Executing-Data-Binding-Arithmetic-Operations\">Auto Executing Data Binding, Arithmetic Operations<\/a><\/li><\/ol><\/li><li>To add data without erasing already stored cell data, use B2.<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-wordpress wp-block-embed-wordpress is-provider-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"1Ztlwt9B9U\"><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-data-assignment\/\">Update Data<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Update Data&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/bpmn-icons\/service-task-data-assignment\/embed\/#?secret=1J0CEmmKrv#?secret=1Ztlwt9B9U\" data-secret=\"1Ztlwt9B9U\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-wordpress wp-block-embed-wordpress is-provider-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"hg7cHyjCP5\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/tsv-string-reorder-columns\/\">TSV String; Re-order Columns<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;TSV String; Re-order Columns&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/tsv-string-reorder-columns\/embed\/#?secret=ElMVieF4pn#?secret=hg7cHyjCP5\" data-secret=\"hg7cHyjCP5\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Duplicates Table-type data. All cell value stored in Table-type data A is copied over Table-type data B. If the table column definitions are different, an error may occur.<\/p>\n","protected":false},"author":2,"featured_media":84788,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[169],"tags":[365,373],"class_list":["post-84787","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-easy-config-addon","tag-listarray"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":1,"uagb_excerpt":"Duplicates Table-type data. All cell value stored in Table-type data A is copied over Table-type data B. If the table column definitions are different, an error may occur.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-m3x","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":108814,"url":"https:\/\/support.questetra.com\/en\/addons\/table-duplicate-2021\/","url_meta":{"origin":84787,"position":0},"title":"Table, Duplicate","author":"IMAMURA, Genichi","date":"2021-08-19","format":false,"excerpt":"Duplicates Table-type data. All cell value stored in Table-type data A is copied over Table-type data B. If the table column definitions are different, an error may occur","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Table, Duplicate","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Table-Duplicate-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69560,"url":"https:\/\/support.questetra.com\/en\/addons\/duplicator-table\/","url_meta":{"origin":84787,"position":1},"title":"Data Duplicator (Table)","author":"Hirotaka NISHI","date":"2018-11-01","format":false,"excerpt":"Duplicates all data stored in table type data items to other table type data. *Note If the number of design columns (number of columns) of the table does not match, it results in an error. (Invalid number of Columns) If the Data types of the columns do not match, it\u2026","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/duplicator-table-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/duplicator-table-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/duplicator-table-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/duplicator-table-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/duplicator-table-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":84857,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-table\/","url_meta":{"origin":84787,"position":2},"title":"Converter: TSV-String to Table","author":"IMAMURA, Genichi","date":"2020-02-28","format":false,"excerpt":"Converts TSV String to Table-type data. The string value of all cells in the TSV string is copied over Table-type data B. If there is an inconsistency in the Table column design, an error may occur.","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Converter: TSV-String to Table","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":84887,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-table-to-tsv-string\/","url_meta":{"origin":84787,"position":3},"title":"Converter: Table to TSV-String","author":"IMAMURA, Genichi","date":"2020-03-02","format":false,"excerpt":"Converts Table-type data to TSV String. The string value of all cells in the Table-type data is copied over TSV string B. Cells with no input are regarded as empty strings.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter: Table to TSV-String","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79781,"url":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","url_meta":{"origin":84787,"position":4},"title":"Table-Type","author":"Peter Glover","date":"2021-01-22","format":false,"excerpt":"Displays a table that can use the String, Numeric, Select or Date formats.","rel":"","context":"In &quot;Data Items&quot;","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69571,"url":"https:\/\/support.questetra.com\/en\/addons\/file-duplicator\/","url_meta":{"origin":84787,"position":5},"title":"Data Duplicator (Files)","author":"Hirotaka NISHI","date":"2016-11-16","format":false,"excerpt":"Duplicate the file of File type data item: A to File type data item: B. *Note Place it before a Step of selecting files or replacing some files Workflow-Sample","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/11\/data-duplicator-files-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/11\/data-duplicator-files-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/11\/data-duplicator-files-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/11\/data-duplicator-files-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/11\/data-duplicator-files-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/84787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=84787"}],"version-history":[{"count":6,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/84787\/revisions"}],"predecessor-version":[{"id":108834,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/84787\/revisions\/108834"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/84788"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=84787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=84787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=84787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}