TSV String, Switch Rows and Columns<\/div>
Switches the row and column indices of the rectangle TSV. The output matrix (transposed matrix) is obtained by changing cell (x,y) to (y,x). Used for data arrangement for frequency distribution tables and histograms.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> A1: Set Input TSV *<\/span>#{EL}<\/sup><\/span><\/li>\n
- B1: Select STRING DATA that stores Output TSV (update) *<\/span><\/li>\n
- B2: Select NUMERIC that stores Num of Rows in Output (update)<\/li>\n
- B3: Select NUMERIC that stores Num of Columns in Output (update)<\/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\/addons\/tsv-string-switch-rows-and-columns-2021\/<\/a>
<\/i> The Add-on import feature is available with Professional<\/strong><\/span> edition.
Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- When the process reaches this automated task, the TSV is read automatically.
- TSV: Sales Records, Survey Records, etc.<\/li><\/ul><\/li>
- If there is a blank line in the input TSV text, it will be skipped.
- The line feed code for the last line is not added either.
-\u3000The output TSV text (total table TSV, etc.) is rectangular data.<\/li> - The number of rows in TSV is the number of types of “aggregate Key”.<\/li>
- The number of columns of TSV is 3; key, count and percentage<\/li><\/ul><\/li><\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"Switches](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-switch-rows-and-columns-2021-capture-en.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"Switches](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-switch-rows-and-columns-2021-config-en-947x630.png?resize=947%2C630&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> Appendix<\/h3>\n\n\n\n
- TSV (Tab Separated Values) text assumes rectangular data.
- The number of rows in the output TSV is the number of columns in the input TSV.<\/li>
- The number of columns in the output TSV is the number of rows in the input TSV.<\/li><\/ul><\/li><\/ul>\n\n\n\n
<\/i> See also<\/h3>\n\n\n\n
- TSV (Tab Separated Values) text assumes rectangular data.
- The line feed code for the last line is not added either.
- When the process reaches this automated task, the TSV is read automatically.
- B1: Select STRING DATA that stores Output TSV (update) *<\/span><\/li>\n