{"id":108814,"date":"2021-08-19T13:20:35","date_gmt":"2021-08-19T04:20:35","guid":{"rendered":"https:\/\/support.questetra.com\/?p=108814"},"modified":"2022-06-09T10:31:00","modified_gmt":"2022-06-09T01:31:00","slug":"table-duplicate-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/table-duplicate-2021\/","title":{"rendered":"Table, Duplicate"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;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\"> Duplicates Table-type data. All cell values stored in Table-type data A is copied over to Table-type data B. If the table column definitions are different, an error may occur.<\/div><\/div>\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<ul class=\"fa-ul\">\n<li> A: Select TABLE DATA<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> B: Select TABLE DATA (update)<\/li>\n<li> B2: Select TABLE DATA (append)<\/li>\n<\/ul>\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 (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\/\/\n\/\/ Notes:\n\/\/ Copies text information of all cell values.\n\/\/ Copies in the display order of the column. (Does not refer to column ID\/field name)\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): &quot;Update Data&quot;\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\/\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\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\u30c7\u30fc\u30bf\u66f4\u65b0\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 &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){\n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst dataIdA = configs.get( &quot;conf_DataIdA&quot; ) + &quot;&quot;; \/\/ required\nconst dataIdB = configs.get( &quot;conf_DataIdB&quot; ) + &quot;&quot;; \/\/ not required\nconst dataIdB2 = configs.get( &quot;conf_DataIdB2&quot; ) + &quot;&quot;; \/\/ not required\n\/\/ &#39;java.lang.String&#39; to javascript primitive &#39;string&#39;\n\nconst numColsA = engine.findDataDefinitionByNumber( dataIdA ).getSubDataDefinitions().size() - 0; \/\/ java.util.List&lt;com.questetra.bpms.core.event.scripttask.SubDataDefinitionView&gt;#size()\nengine.log( &quot; AutomatedTask TableConfig:&quot; +\n            &quot; #of {A}-Columns Definition: &quot; + numColsA );\n\nlet outputTable1ProcessDataDefinitionView = null;\nlet outputTable1DataDefinition = null;\nlet outputTable1 = null;\nlet numColsB = 0;\nif( dataIdB !== &quot;&quot; ){\n  outputTable1ProcessDataDefinitionView = engine.findDataDefinitionByNumber( dataIdB ); \/\/ com.questetra.bpms.core.event.scripttask.ProcessDataDefinitionView\n  outputTable1DataDefinition = outputTable1ProcessDataDefinitionView.getSubDataDefinitions(); \/\/ java.util.List&lt;com.questetra.bpms.core.event.scripttask.SubDataDefinitionView&gt;\n  outputTable1 = outputTable1ProcessDataDefinitionView.createListArray(); \/\/ com.questetra.bpms.core.event.scripttask.ScriptListArray\n  numColsB = outputTable1DataDefinition.size() - 0;\n  engine.log( &quot; AutomatedTask TableConfig:&quot; +\n              &quot; #of {B}-Columns Definition: &quot; + numColsB );\n}\n\nlet outputTable2ProcessDataDefinitionView = null;\nlet outputTable2DataDefinition = null;\nlet outputTable2 = null;\nlet numColsB2 = 0;\nif( dataIdB2 !== &quot;&quot; ){\n  outputTable2ProcessDataDefinitionView = engine.findDataDefinitionByNumber( dataIdB2 ); \/\/ com.questetra.bpms.core.event.scripttask.ProcessDataDefinitionView\n  outputTable2DataDefinition = outputTable2ProcessDataDefinitionView.getSubDataDefinitions(); \/\/ java.util.List&lt;com.questetra.bpms.core.event.scripttask.SubDataDefinitionView&gt;\n  outputTable2 = engine.findDataByNumber( dataIdB2 ); \/\/ com.questetra.bpms.core.event.scripttask.ScriptListArray\n  if( outputTable2 === null ){\n    \/\/ Table with zero rows.\n    outputTable2 = outputTable2ProcessDataDefinitionView.createListArray(); \/\/ com.questetra.bpms.core.event.scripttask.ScriptListArray\n  }\n  numColsB2 = outputTable2DataDefinition.size() - 0;\n  engine.log( &quot; AutomatedTask TableConfig:&quot; +\n              &quot; #of {B2}-Columns Definition: &quot; + 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.event.scripttask.ScriptListArray (BPMS Table)\n\/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300\nif( inputTable === null ){\n  throw new Error( &quot;\\n AutomatedTask UnexpectedTableError:&quot; +\n                   &quot; Table {A} is empty \\n&quot; );\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nif( dataIdB !== &quot;&quot; ){\n  for( let i = 0; i &lt; inputTable.size() - 0; i++ ){\n    let tmpRow = outputTable1.addRow(); \/\/ com.questetra.bpms.core.event.scripttask.ScriptListArray.ScriptListRow\n    if( numColsA &lt; numColsB ){\n      for( let j = 0; j &lt; numColsA; j++ ){\n        tmpRow.setCol( j, inputTable.getRow(i).getCol(j) );\n      }\n      for( let k = numColsA; k &lt; numColsB; k++ ){\n        tmpRow.setCol( k, &quot;&quot; ); \/\/ Fill with empty characters\n      }\n    }\n    if( numColsA &gt;= numColsB ){\n      for( let j = 0; j &lt; numColsB; j++ ){\n        tmpRow.setCol( j, inputTable.getRow(i).getCol(j) );\n      }\n    }\n    engine.log( &quot; AutomatedTask:&quot; +\n                &quot; Add B[&quot; + i + &quot;]&quot; );\n  }\n}\n\nif( dataIdB2 !== &quot;&quot; ){\n  let numOriginLines = outputTable2.size() - 0;\n  engine.log( &quot; AutomatedTask:&quot; +\n              &quot; #of {B2}-Rows: &quot; + numOriginLines );\n\n  for( let i = 0; i &lt; inputTable.size() - 0; i++ ){\n    let tmpRow = outputTable2.addRow(); \/\/ com.questetra.bpms.core.event.scripttask.ScriptListArray.ScriptListRow\n    if( numColsA &lt; numColsB2 ){\n      for( let j = 0; j &lt; numColsA; j++ ){\n        tmpRow.setCol( j, inputTable.getRow(i).getCol(j) );\n      }\n      for( let k = numColsA; k &lt; numColsB2; k++ ){\n        tmpRow.setCol( k, &quot;&quot; ); \/\/ Fill with empty characters\n      }\n    }\n    if( numColsA &gt;= numColsB2 ){\n      for( let j = 0; j &lt; numColsB2; j++ ){\n        tmpRow.setCol( j, inputTable.getRow(i).getCol(j) );\n      }\n    }\n    engine.log( &quot; AutomatedTask:&quot; +\n                &quot; Add B2[&quot; + (numOriginLines + i) + &quot;]&quot; );\n  }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( dataIdB !== &quot;&quot; ){\n  engine.setDataByNumber( dataIdB, outputTable1 );\n}\nif( dataIdB2 !== &quot;&quot; ){\n  engine.setDataByNumber( dataIdB2, outputTable2 );\n}\n\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADCUlEQVRYR82XT0iTcRjHP6\/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\n\" alt=\"\"\/><\/a><\/figure><\/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\/file\/d\/1nScJWmE4f04dHV9lFSk4xhMqeK512P5C\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">Table-Duplicate.xml<\/a><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2021-08-19 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/en\/addons\/table-duplicate-2021\/\">https:\/\/support.questetra.com\/addons\/table-duplicate-2021\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Add-on import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\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-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 the columns in the order in which they appear (regardless of the column ID\/field name).<\/li><li>If the number of columns decreases, the right columns will not be copied.<\/li><li>If the number of columns increases, the extra columns will be completed with blank strings.<\/li><li>To re-order columns, consider Table-TsvString-TsvEdit-Table.<\/li><li>Auto-calculated columns are re-evaluated. (They will not necessarily have the same value.)<\/li><li>Use the standard functions 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;Update Data&#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-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/07\/table-duplicate-en.png?ssl=1\" alt=\"\" class=\"wp-image\" 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-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-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"I9ljmLWxnO\"><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=AjhGl5GjWA#?secret=I9ljmLWxnO\" data-secret=\"I9ljmLWxnO\" 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-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"RaTliVcqoB\"><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=5PZThHNlLz#?secret=RaTliVcqoB\" data-secret=\"RaTliVcqoB\" 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":"closed","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_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","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":[168],"tags":[365,373],"faq_section":[],"class_list":["post-108814","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-easy-config-addon","tag-listarray"],"jetpack_publicize_connections":[],"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-sj4","jetpack-related-posts":[{"id":84787,"url":"https:\/\/support.questetra.com\/en\/addons\/table-duplicate\/","url_meta":{"origin":108814,"position":0},"title":"Table, Duplicate","author":"IMAMURA, Genichi","date":"2020-02-26","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":84887,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-table-to-tsv-string\/","url_meta":{"origin":108814,"position":1},"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":84857,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-table\/","url_meta":{"origin":108814,"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;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/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":69560,"url":"https:\/\/support.questetra.com\/en\/addons\/duplicator-table\/","url_meta":{"origin":108814,"position":3},"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;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/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":79781,"url":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","url_meta":{"origin":108814,"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":74361,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-model-xml-extract-definition\/","url_meta":{"origin":108814,"position":5},"title":"Questetra-Model-XML \u30c7\u30fc\u30bf\u5b9a\u7fa9\u306e\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-01-18","format":false,"excerpt":"\u696d\u52d9\u30d7\u30ed\u30bb\u30b9\u306e\u5b9a\u7fa9\u6982\u8981\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002QAR \u30a2\u30fc\u30ab\u30a4\u30d6\u5185 Model-XML \u30d5\u30a1\u30a4\u30eb\u306b\u3042\u308b process-data-definition\uff08number, data-type, name\uff09\u3084 Node\uff08\"number\", \"name\", \"nodeType\"\uff09\u306e\u4e00\u90e8\u60c5\u5831\u304c TSV \u3082\u3057\u304f\u306f WordPress-HTML \u3068\u3057\u3066\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002","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":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/questetra-model-xml-extract-header-ja.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\/01\/questetra-model-xml-extract-header-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/questetra-model-xml-extract-header-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/questetra-model-xml-extract-header-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/questetra-model-xml-extract-header-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"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","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/108814","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=108814"}],"version-history":[{"count":14,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/108814\/revisions"}],"predecessor-version":[{"id":114864,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/108814\/revisions\/114864"}],"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=108814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=108814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=108814"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=108814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}