- \n
- <\/i><\/span> A1: Input TSV \u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B1: Output TSV \u304c\u683c\u7d0d\u3055\u308c\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0) *<\/span><\/li>\n
- <\/i><\/span> B2: \u51fa\u529b\u884c\u6570\u304c\u683c\u7d0d\u3055\u308c\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/li>\n
- <\/i><\/span> B3: \u51fa\u529b\u5217\u6570\u304c\u683c\u7d0d\u3055\u308c\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strTsv = configs.get( "StrConfA1" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\/\/\n if( strTsv === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A1: Tsv} is empty \\n" );\n }\n const arr2dTsv = parseAsRectangular( strTsv );\nconst strPocketOutput = configs.getObject( "SelectConfB1" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\nconst numPocketNumOfRows = configs.getObject( "SelectConfB2" ); \/\/ NotRequired \/\/\/\/\/\nconst numPocketNumOfColumns = configs.getObject( "SelectConfB3" ); \/\/ NotRequired \/\/\/\/\/\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\n\/\/ output TSV\nlet strOutput = "";\nfor( let x = 0; x < arr2dTsv[0].length; x++ ){ \/\/ Will be Y in the new TSV\n for( let y = 0; y < arr2dTsv.length; y++ ){ \/\/ Concatenate vertical data horizontally\n strOutput += arr2dTsv[y][x];\n if( y !== arr2dTsv.length - 1 ){\n strOutput += "\\t";\n }\n }\n if( x !== arr2dTsv[0].length - 1 ){\n strOutput += "\\n";\n }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( strPocketOutput, strOutput );\nif( numPocketNumOfRows !== null ){\n engine.setData( numPocketNumOfRows, new java.math.BigDecimal( arr2dTsv[0].length ) );\n}\nif( numPocketNumOfColumns !== null ){\n engine.setData( numPocketNumOfColumns, new java.math.BigDecimal( arr2dTsv.length ) );\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/\/ Parses TSV string as two-dimensional rectangular data matrix and creates a 2D array.\nfunction parseAsRectangular( strTsv ){\n const arrTsv = strTsv.split("\\n");\n\n \/\/\/ Get numMinWidth and numMaxWidth (blank lines are excluded)\n let numMinWidth = Infinity; \/\/ cf. String-Type Max: 1 million\n let numMaxWidth = 0;\n let numBlanklines = 0;\n for( let i = 0; i < arrTsv.length; i++ ){\n if( arrTsv[i] === "" ){ \/\/ Skip blank lines\n numBlanklines += 1;\n continue;\n }\n let arrCells = arrTsv[i].split("\\t");\n if( numMinWidth > arrCells.length ){ numMinWidth = arrCells.length; }\n if( numMaxWidth < arrCells.length ){ numMaxWidth = arrCells.length; }\n }\n engine.log( " AutomatedTask TsvDataCheck:" + \n " MinWidth:" + numMinWidth +\n " MaxWidth:" + numMaxWidth +\n " Lines:" + arrTsv.length +\n " (BlankLines:" + numBlanklines + ")" );\n\n \/\/\/ Get numMinWidth and numMaxWidth (blank lines are excluded)\n let arr2dTsv = [];\n for( let i = 0; i < arrTsv.length; i++ ){\n if( arrTsv[i] === "" ){ \/\/ Skip blank lines\n continue;\n }\n let arrTmp = [];\n let arrCells = arrTsv[i].split("\\t");\n for( let j = 0; j < numMaxWidth; j++ ){\n if( j < arrCells.length ){\n arrTmp[j] = arrCells[j];\n }else{\n arrTmp[j] = "";\n }\n }\n arr2dTsv.push( arrTmp );\n }\n\n return arr2dTsv;\n}\n\n\/*\nTSV Example:\n2021-08\t1,400\n2021-09\t2,500\n2021-10\t1,900\n\nNotes:\n- When the process reaches this automated task, TSV is automatically read.\n - TSV: Sales Records, Survey Records, etc.\n- If there is a blank line in the input TSV text, it will be skipped.\n - The line feed code for the last line is not added either.\n-\u3000The output TSV text (total table TSV, etc.) is rectangular data.\n - The number of rows in TSV is the number of types of "aggregate Key".\n - The number of columns of TSV is 3 of "key", "count" and "percentage"\n\nAPPENDIX:\n- TSV (Tab Separated Values) text assumes rectangular data.\n - The number of rows in the output TSV is the number of columns in the input TSV.\n - The number of columns in the output TSV is the number of rows in the input TSV.\n\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308bTSV\u304c\u81ea\u52d5\u7684\u306b\u8aad\u307f\u8fbc\u307e\u308c\u307e\u3059\u3002\n - TSV: \u58f2\u4e0a\u30ec\u30b3\u30fc\u30c9\u3001\u30a2\u30f3\u30b1\u30fc\u30c8\u56de\u7b54\u30ed\u30b0\u3001\u306a\u3069\n- \u5165\u529bTSV\u30c6\u30ad\u30b9\u30c8\u306b\u7a7a\u884c\u304c\u3042\u308b\u5834\u5408\u3001\u30b9\u30ad\u30c3\u30d7\u3055\u308c\u307e\u3059\u3002\n - \u51fa\u529bTSV\u306e\u6700\u7d42\u884c\u306b\u6539\u884c\u30b3\u30fc\u30c9\u306f\u4ed8\u4e0e\u3055\u308c\u307e\u305b\u3093\u3002\n- \u51fa\u529b\u3055\u308c\u308bTSV\u30c6\u30ad\u30b9\u30c8\uff08\u5408\u8a08\u5024\u30c6\u30fc\u30d6\u30ebTSV\u7b49\uff09\u306f\u3001\u77e9\u5f62\u30c7\u30fc\u30bf\u3067\u3059\u3002\n - \u51fa\u529bTSV\u306e\u884c\u6570\u306f\u3001\u5165\u529bTSV\u306e\u5217\u6570\u3067\u3059\u3002\n - \u51fa\u529bTSV\u306e\u5217\u6570\u306f\u3001\u5165\u529bTSV\u306e\u884c\u6570\u3067\u3059\u3002\n\nAPPENDIX-ja:\n- TSV\uff08Tab Separated Values\uff09\u30c6\u30ad\u30b9\u30c8\u306f\u3001\u77e9\u5f62\u30c7\u30fc\u30bf\u3092\u524d\u63d0\u3068\u3057\u307e\u3059\u3002\n - \u77e9\u5f62\u3067\u306a\u3044\u30c7\u30fc\u30bf\u306f\u3001\u7a7a\u6587\u5b57\u306b\u3088\u3063\u3066\u81ea\u52d5\u6574\u5f62\u3055\u308c\u307e\u3059\u3002\n - \u7a7a\u884c\uff08\u672b\u5c3e\u6539\u884c\u3092\u542b\u3080\uff09\u306f\u7121\u8996\u3055\u308c\u307e\u3059\u3002\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure><\/div>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- Tsv-String-Switch-Rows-and-Columns-2021.xml<\/a><\/li><\/ul>\n\n\n\n
2021-09-10 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/ja\/addons\/tsv-string-switch-rows-and-columns-2021\/<\/a>
<\/i> Addon\u30d5\u30a1\u30a4\u30eb\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306f Professional<\/strong><\/span> \u3067\u306e\u307f\u3054\u5229\u7528\u3044\u305f\u3060\u3051\u307e\u3059\u3002
\u81ea\u7531\u6539\u5909\u53ef\u80fd\u306a JavaScript (ECMAScript) \u30b3\u30fc\u30c9\u3067\u3059\u3002\u3044\u304b\u306a\u308b\u4fdd\u8a3c\u3082\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \u6848\u4ef6\u304c\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308bTSV\u304c\u81ea\u52d5\u7684\u306b\u8aad\u307f\u8fbc\u307e\u308c\u307e\u3059\u3002
- TSV: \u58f2\u4e0a\u30ec\u30b3\u30fc\u30c9\u3001\u30a2\u30f3\u30b1\u30fc\u30c8\u56de\u7b54\u30ed\u30b0\u3001\u306a\u3069<\/li><\/ul><\/li>
- \u5165\u529bTSV\u30c6\u30ad\u30b9\u30c8\u306b\u7a7a\u884c\u304c\u3042\u308b\u5834\u5408\u3001\u30b9\u30ad\u30c3\u30d7\u3055\u308c\u307e\u3059\u3002
- \u51fa\u529bTSV\u306e\u6700\u7d42\u884c\u306b\u6539\u884c\u30b3\u30fc\u30c9\u306f\u4ed8\u4e0e\u3055\u308c\u307e\u305b\u3093\u3002<\/li><\/ul><\/li>
- \u51fa\u529b\u3055\u308c\u308bTSV\u30c6\u30ad\u30b9\u30c8\uff08\u5408\u8a08\u5024\u30c6\u30fc\u30d6\u30ebTSV\u7b49\uff09\u306f\u3001\u77e9\u5f62\u30c7\u30fc\u30bf\u3067\u3059\u3002
- \u51fa\u529bTSV\u306e\u884c\u6570\u306f\u3001\u5165\u529bTSV\u306e\u5217\u6570\u3067\u3059\u3002<\/li>
- \u51fa\u529bTSV\u306e\u5217\u6570\u306f\u3001\u5165\u529bTSV\u306e\u884c\u6570\u3067\u3059\u3002<\/li><\/ul><\/li><\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"\u77e9\u5f62TSV\u3092\u884c\u3068\u5217\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u5165\u308c\u66ff\u3048\u307e\u3059\u3002\u51fa\u529b\u3055\u308c\u308b\u30de\u30c8\u30ea\u30c3\u30af\u30b9TSV\uff08\u8ee2\u7f6e\u884c\u5217\uff09\u306f\u3001\u884c\u5217\u8981\u7d20(x,y)\u304c(y,x)\u306b\u7f6e\u304d\u63db\u3048\u3089\u308c\u305f\u884c\u5217\u306b\u306a\u308a\u307e\u3059\u3002\u5ea6\u6570\u5206\u5e03\u8868\u3084\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u306e\u305f\u3081\u306e\u30c7\u30fc\u30bf\u6574\u5f62\u7b49\u306b\u4f7f\u308f\u308c\u307e\u3059\u3002\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-switch-rows-and-columns-2021-capture-ja.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"\u77e9\u5f62TSV\u3092\u884c\u3068\u5217\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u5165\u308c\u66ff\u3048\u307e\u3059\u3002\u51fa\u529b\u3055\u308c\u308b\u30de\u30c8\u30ea\u30c3\u30af\u30b9TSV\uff08\u8ee2\u7f6e\u884c\u5217\uff09\u306f\u3001\u884c\u5217\u8981\u7d20(x,y)\u304c(y,x)\u306b\u7f6e\u304d\u63db\u3048\u3089\u308c\u305f\u884c\u5217\u306b\u306a\u308a\u307e\u3059\u3002\u5ea6\u6570\u5206\u5e03\u8868\u3084\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u306e\u305f\u3081\u306e\u30c7\u30fc\u30bf\u6574\u5f62\u7b49\u306b\u4f7f\u308f\u308c\u307e\u3059\u3002\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-switch-rows-and-columns-2021-config-ja.png?resize=948%2C630&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> Appendix<\/h3>\n\n\n\n
- TSV \uff08Tab Separated Values\uff09\u30c6\u30ad\u30b9\u30c8\u306f\u3001\u77e9\u5f62\u30c7\u30fc\u30bf\u3092\u524d\u63d0\u3068\u3057\u307e\u3059\u3002
- \u77e9\u5f62\u3067\u306a\u3044\u30c7\u30fc\u30bf\u306f\u3001\u7a7a\u6587\u5b57\u306b\u3088\u3063\u3066\u81ea\u52d5\u6574\u5f62\u3055\u308c\u307e\u3059\u3002<\/li>
- \u7a7a\u884c\uff08\u672b\u5c3e\u6539\u884c\u3092\u542b\u3080\uff09\u306f\u7121\u8996\u3055\u308c\u307e\u3059\u3002<\/li><\/ul><\/li><\/ul>\n\n\n\n
<\/i> See also<\/h3>\n\n\n\n
- TSV \uff08Tab Separated Values\uff09\u30c6\u30ad\u30b9\u30c8\u306f\u3001\u77e9\u5f62\u30c7\u30fc\u30bf\u3092\u524d\u63d0\u3068\u3057\u307e\u3059\u3002
- \u6848\u4ef6\u304c\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308bTSV\u304c\u81ea\u52d5\u7684\u306b\u8aad\u307f\u8fbc\u307e\u308c\u307e\u3059\u3002
- <\/i><\/span> B1: Output TSV \u304c\u683c\u7d0d\u3055\u308c\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0) *<\/span><\/li>\n