{"id":189464,"date":"2026-07-08T14:02:00","date_gmt":"2026-07-08T05:02:00","guid":{"rendered":"https:\/\/support.questetra.com\/?p=189464"},"modified":"2026-07-09T16:15:32","modified_gmt":"2026-07-09T07:15:32","slug":"date-tsv-create-pivot-by-month-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/date-tsv-create-pivot-by-month-2026\/","title":{"rendered":"\u65e5\u4ed8 #TSV: \u6708\u6b21\u30d4\u30dc\u30c3\u30c8\u751f\u6210"},"content":{"rendered":"\n

Overview<\/h3>\n\n\n\n

\u65e5\u4ed8 #TSV: \u6708\u6b21\u30d4\u30dc\u30c3\u30c8\u751f\u6210<\/strong><\/h4>\n\n\n\n

translate<\/span> Date #TSV: Create Pivot by Month<\/p>\n\n\n\n

\u65e5\u4ed8TSV\u5185\u306e\u65e5\u4ed8\u5217\u3092Y\u8ef8\uff08\u6708\u6b21\uff09\u3001\u4efb\u610f\u306e\u5217\u3092X\u8ef8\u3068\u3057\u3066\u3001\u30af\u30ed\u30b9\u96c6\u8a08\uff08\u884c\u6570\u3001\u7d2f\u8a08\u548c\u3001\u5e73\u5747\uff09\u3092\u751f\u6210\u3057\u307e\u3059\u3002\u306a\u304a\u3001Date \u5217\u306e\u5834\u6240\u306fA\u5217\uff08id=0\uff09\u306b\u9650\u3089\u305a\u3001\u4efb\u610f\u306e\u5217\u4f4d\u7f6e\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002\u307e\u305f Datetime \u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u306a\u3063\u3066\u3044\u3066\u3082\u69cb\u3044\u307e\u305b\u3093\u3002<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
StrConfA<\/dt>
A: \u5165\u529bTSV\u6587\u5b57\u5217\uff08\u65e5\u4ed8\u5217\u3092\u542b\u3080TSV\uff09\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfB1<\/dt>
B1: \u65e5\u4ed8\u5217\u306eID\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08A\u5217\u306f”0″\u3001B\u5217\u306f”1″\uff09 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfB2<\/dt>
B2: \u5408\u8a08\u3059\u308b\u6570\u5024\u5217\u306eID\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u7121\u6307\u5b9a\u306e\u5834\u5408,\u7d2f\u8a08\/\u5e73\u5747\u306f\u51fa\u529b\u3055\u308c\u307e\u305b\u3093\uff09#{EL}<\/sup><\/span><\/dd>\n
StrConfB3<\/dt>
B3: X\u8ef8\u96c6\u7d04\u30ad\u30fc\u3068\u306a\u308b\u5217\u306eID\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08A\u5217\u306f”0″\u3001B\u5217\u306f”1″\uff09 *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfC2<\/dt>
C2: FY\u65b9\u5f0f\u306b\u5909\u66f4\u3057\u305f\u3044\u5834\u5408\u3001\u6c7a\u7b97\u6708\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u4f8b: “3”; Q-202604~06 \u2192 FY2027-Q1\uff09#{EL}<\/sup><\/span><\/dd>\n
SelectConfC3<\/dt>
C3: \u884c\u6570TSV\u304c\u683c\u7d0d\u3055\u308c\u308b\u8907\u6570\u884c\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfC4<\/dt>
C4: \u7d2f\u8a08\u548cTSV\u304c\u683c\u7d0d\u3055\u308c\u308b\u8907\u6570\u884c\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfC5<\/dt>
C5: \u5e73\u5747TSV\u304c\u683c\u7d0d\u3055\u308c\u308b\u8907\u6570\u884c\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n<\/div>\n
SelectConfD1<\/dt>
D1: \u5165\u529bTSV\u884c\u6570\u3092\u683c\u7d0d\u3059\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfD2<\/dt>
D2: \u5165\u529bTSV\u884c\u6570\uff08\u7a7a\u884c\u3092\u7121\u8996\uff09\u3092\u683c\u7d0d\u3059\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n
SelectConfD3<\/dt>
D3: \u51fa\u529bTSV\u884c\u6570\u3092\u683c\u7d0d\u3059\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\n<\/div>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/\/ Script Example of Business Process Automation\n\/\/ for 'engine type: 3' ("GraalJS standard mode")\n\/\/ cf. 'engine type: 2' ("GraalJS Nashorn compatible mode") (renamed from "GraalJS" at 20230526)\n\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        ( "StrConfA" );     \/\/ REQUIRED\n  if( strTsv === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A: TSV} is empty \\n" );\n  }\n  const arr2dTsv     = parseAsRectangular ( strTsv );  \/\/ [row,col]\nconst strColIdDate   = configs.get( "StrConfB1" );            \/\/ REQUIRED\nconst strColIdsNum   = configs.get( "StrConfB2" );            \/\/ not required\nconst strColIdX      = configs.get( "StrConfB3" );            \/\/ REQUIRED\nconst strFyMonth     = configs.get( "StrConfC2" );            \/\/ not required\nconst strPocketC3    = configs.getObject ( "SelectConfC3" );  \/\/ not required\nconst strPocketC4    = configs.getObject ( "SelectConfC4" );  \/\/ not required\nconst strPocketC5    = configs.getObject ( "SelectConfC5" );  \/\/ not required\nconst numPocketD1    = configs.getObject ( "SelectConfD1" );  \/\/ not required\nconst numPocketD2    = configs.getObject ( "SelectConfD2" );  \/\/ not required\nconst numPocketD3    = configs.getObject ( "SelectConfD3" );  \/\/ not required\n\n\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\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/ \u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u30d1\u30fc\u30b9\u3068\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\nconst idxDate = parseInt(strColIdDate, 10);\nif (isNaN(idxDate) || idxDate < 0) {\n  throw new Error("\\n AutomatedTask ConfigError: Invalid Date Column ID in B1 \\n");\n}\n\nconst idxX = parseInt(strColIdX, 10);\nif (isNaN(idxX) || idxX < 0) {\n  throw new Error("\\n AutomatedTask ConfigError: Invalid X-axis Column ID in B3 \\n");\n}\n\nlet idxNum = NaN;\nif (strColIdsNum !== "") {\n  idxNum = parseInt(strColIdsNum.trim(), 10);\n  if (isNaN(idxNum) || idxNum < 0) {\n    throw new Error("\\n AutomatedTask ConfigError: Invalid Numeric Column ID in B2 \\n");\n  }\n}\n\nlet yeMonth = 0;\nif (strFyMonth !== "") {\n  yeMonth = parseInt(strFyMonth, 10);\n  if (isNaN(yeMonth) || yeMonth < 0 || yeMonth > 12) {\n    throw new Error("\\n AutomatedTask ConfigError: Invalid YE Month in C2 (must be 1-12) \\n");\n  }\n}\n\n\/\/ \u30d8\u30c3\u30c0\u30fc\u884c\u306e\u51e6\u7406\u3068\u30c1\u30a7\u30c3\u30af\nif (arr2dTsv.length === 0) {\n  throw new Error("\\n AutomatedTask DataError: Input TSV is empty \\n");\n}\nconst headerRow = arr2dTsv[0];\nif (idxDate >= headerRow.length) {\n  throw new Error(`\\n AutomatedTask ConfigError: Date Column ID (${idxDate}) is out of bounds \\n`);\n}\nif (idxX >= headerRow.length) {\n  throw new Error(`\\n AutomatedTask ConfigError: X-axis Column ID (${idxX}) is out of bounds \\n`);\n}\nif (!isNaN(idxNum) && idxNum >= headerRow.length) {\n  throw new Error(`\\n AutomatedTask ConfigError: Numeric Column ID (${idxNum}) is out of bounds \\n`);\n}\n\n\/\/ X\u8ef8\u306e\u4e00\u610f\u306a\u5024\u3092\u62bd\u51fa\u3057\u3001\u5168\u4f53\u306e\u5408\u8a08\u5024\uff08\u6570\u5024\u5217\u306e\u7dcf\u548c\u3001\u307e\u305f\u306f\u884c\u6570\uff09\u3067\u964d\u9806\u30bd\u30fc\u30c8\u3059\u308b\u305f\u3081\u306e\u6e96\u5099\nconst xLabelsSet = new Set();\nconst mapXTotal = new Map();\n\nfor (let i = 1; i < arr2dTsv.length; i++) {\n  const row = arr2dTsv[i];\n  const strDate = row[idxDate];\n  if (idxX < row.length) {\n    const xVal = row[idxX].trim();\n    if (xVal !== "") {\n      xLabelsSet.add(xVal);\n      \n      \/\/ \u6709\u52b9\u306a\u30c7\u30fc\u30bf\u884c\uff08\u65e5\u4ed8\u304c\u7a7a\u3067\u306a\u3044\uff09\u306e\u5834\u5408\u306e\u307f\u30bd\u30fc\u30c8\u7528\u5408\u8a08\u306b\u30ab\u30a6\u30f3\u30c8\n      if (strDate && strDate.trim() !== "") {\n        if (!mapXTotal.has(xVal)) {\n          mapXTotal.set(xVal, 0);\n        }\n        \n        if (!isNaN(idxNum) && idxNum < row.length) {\n          const cellVal = row[idxNum];\n          if (cellVal !== "") {\n            const numValStr = cellVal.replace(\/[^0-9.-]\/g, ''); \n            const numVal = Number(numValStr);\n            if (numValStr !== "" && !isNaN(numVal)) {\n              mapXTotal.set(xVal, mapXTotal.get(xVal) + numVal);\n            }\n          }\n        } else {\n          mapXTotal.set(xVal, mapXTotal.get(xVal) + 1);\n        }\n      }\n    }\n  }\n}\n\n\/\/ \u5168\u4f53\u306e\u5408\u8a08\u5024\u304c\u5927\u304d\u3044\u9806\uff08\u964d\u9806\uff09\u306bX\u8ef8\u30e9\u30d9\u30eb\u3092\u30bd\u30fc\u30c8\nconst xLabels = Array.from(xLabelsSet).sort((a, b) => {\n  const totalA = mapXTotal.get(a) || 0;\n  const totalB = mapXTotal.get(b) || 0;\n  return totalB - totalA; \n});\n\n\/\/ \u96c6\u8a08\u51e6\u7406\u306e\u6e96\u5099\n\/\/ mapPivot: key = yLabel + "\\t" + xLabel, value = { count: 0, sum: 0 }\nconst mapPivot = new Map();\nlet minAbsM = Infinity;\nlet maxAbsM = -Infinity;\n\n\/\/ \u30c7\u30fc\u30bf\u884c\u306e\u30eb\u30fc\u30d7\uff081\u884c\u76ee\u306f\u30d8\u30c3\u30c0\u30fc\u3068\u3057\u3066\u30b9\u30ad\u30c3\u30d7\uff09\nfor (let i = 1; i < arr2dTsv.length; i++) {\n  const row = arr2dTsv[i];\n  const strDate = row[idxDate];\n  const strX = row[idxX] ? row[idxX].trim() : "";\n\n  \/\/ \u65e5\u4ed8\u307e\u305f\u306fX\u8ef8\u306e\u5024\u304c\u7a7a\u306a\u3089\u30b9\u30ad\u30c3\u30d7\n  if (!strDate || strDate.trim() === "" || strX === "") continue;\n\n  let dateObj;\n  try {\n    dateObj = parseAsLocalDate(strDate);\n  } catch (e) {\n    engine.log(`Row ${i + 1} skipped: Failed to parse date "${strDate}".`);\n    continue;\n  }\n\n  \/\/ \u30e9\u30d9\u30eb\u3068\u7d76\u5bfe\u6708\u756a\u53f7\u306e\u53d6\u5f97\n  const mInfo = getMonthInfo(dateObj, yeMonth);\n  const yLabel = mInfo.label;\n  const absM = mInfo.absM;\n\n  \/\/ \u6700\u5c0f\u30fb\u6700\u5927\u306e\u6708\u3092\u8a18\u9332\n  if (absM < minAbsM) minAbsM = absM;\n  if (absM > maxAbsM) maxAbsM = absM;\n\n  const key = yLabel + "\\t" + strX;\n  if (!mapPivot.has(key)) {\n    mapPivot.set(key, { count: 0, sum: 0 });\n  }\n\n  const data = mapPivot.get(key);\n  data.count++;\n\n  \/\/ \u6570\u5024\u5217\u306e\u52a0\u7b97\n  if (!isNaN(idxNum) && idxNum < row.length) {\n    const cellVal = row[idxNum];\n    if (cellVal !== "") {\n      const numValStr = cellVal.replace(\/[^0-9.-]\/g, ''); \n      const numVal = Number(numValStr);\n      \n      if (numValStr !== "" && !isNaN(numVal)) {\n        data.sum += numVal;\n      } else if (cellVal.trim() !== "") {\n        engine.log(`Row ${i + 1} Col ${idxNum} warning: Unparseable number "${cellVal}".`);\n      }\n    }\n  }\n}\n\n\/\/ Y\u8ef8\u306e\u6708\u6b21\u30e9\u30d9\u30eb\u306e\u30ea\u30b9\u30c8\uff08\u30c8\u30d3\u306e\u7a74\u57cb\u3081\u3092\u542b\u3080\uff09\nconst yLabels = [];\nif (minAbsM !== Infinity) {\n  for (let m = minAbsM; m <= maxAbsM; m++) {\n    yLabels.push(getLabelFromAbsoluteMonth(m, yeMonth));\n  }\n}\n\n\/\/ ==== \u51fa\u529b\u7528TSV\u306e\u69cb\u7bc9 ====\nconst arrCountTsv = [];\nconst arrSumTsv = [];\nconst arrAvgTsv = [];\n\n\/\/ \u30d8\u30c3\u30c0\u30fc\u8a2d\u5b9a\nconst xHeaderName = headerRow[idxX] ? `(${headerRow[idxX]})` : "(Source)";\nconst tsvHeader = [xHeaderName].concat(xLabels).join("\\t");\n\narrCountTsv.push(tsvHeader);\nif (!isNaN(idxNum)) {\n  arrSumTsv.push(tsvHeader);\n  arrAvgTsv.push(tsvHeader);\n}\n\n\/\/ \u30c7\u30fc\u30bf\u884c\u306e\u69cb\u7bc9\nfor (const yLabel of yLabels) {\n  const rowCount = [yLabel];\n  const rowSum = [yLabel];\n  const rowAvg = [yLabel];\n\n  for (const xLabel of xLabels) {\n    const key = yLabel + "\\t" + xLabel;\n    const data = mapPivot.get(key);\n\n    const count = data ? data.count : 0;\n    const sum = data ? data.sum : 0;\n    \n    const avg = (data && data.count > 0) ? Number((data.sum \/ data.count).toFixed(2)) : 0;\n\n    rowCount.push(String(count));\n    if (!isNaN(idxNum)) {\n      rowSum.push(String(sum));\n      rowAvg.push(String(avg));\n    }\n  }\n\n  arrCountTsv.push(rowCount.join("\\t"));\n  if (!isNaN(idxNum)) {\n    arrSumTsv.push(rowSum.join("\\t"));\n    arrAvgTsv.push(rowAvg.join("\\t"));\n  }\n}\n\n\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\n\nif ( strPocketC3 !== null ){ \n  engine.setData( strPocketC3, arrCountTsv?.join( '\\n' ) ?? "" );\n}\nif ( strPocketC4 !== null ){ \n  engine.setData( strPocketC4, !isNaN(idxNum) ? (arrSumTsv?.join( '\\n' ) ?? "") : "" );\n}\nif ( strPocketC5 !== null ){ \n  engine.setData( strPocketC5, !isNaN(idxNum) ? (arrAvgTsv?.join( '\\n' ) ?? "") : "" );\n}\n\nif ( numPocketD1 !== null ){ \n  engine.setData( numPocketD1, new java.math.BigDecimal( strTsv.split("\\n").length ) );\n}\nif ( numPocketD2 !== null ){ \n  engine.setData( numPocketD2, new java.math.BigDecimal( arr2dTsv.length ) );\n}\nif ( numPocketD3 !== null ){ \n  engine.setData( numPocketD3, new java.math.BigDecimal( arrCountTsv.length ) );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\/**\n * \u65e5\u4ed8\u3068\u6c7a\u7b97\u6708\u304b\u3089\u6708\u6b21\u30e9\u30d9\u30eb\u3068\u7d76\u5bfe\u6708\u756a\u53f7\uff08\u30bd\u30fc\u30c8\u30fb\u88dc\u9593\u7528\uff09\u3092\u751f\u6210\u3059\u308b\n * @param {Date} dateObj - JavaScript Date object\n * @param {number} yeMonth - Year End Month (0 for standard month, 1-12 for FY)\n * @returns {Object} { label: string, absM: number }\n *\/\nfunction getMonthInfo(dateObj, yeMonth) {\n  const y = dateObj.getFullYear();\n  const m = dateObj.getMonth() + 1; \/\/ 1-12\n\n  if (yeMonth === 0) {\n    \/\/ \u901a\u5e38\u306e\u6708\u6b21 (YYYY-MM)\n    const absM = y * 12 + (m - 1);\n    const mStr = m < 10 ? `0${m}` : `${m}`;\n    return { label: `${y}-${mStr}`, absM: absM };\n  } else {\n    \/\/ FY\u30d9\u30fc\u30b9\u306e\u6708\u6b21 (FYYYY-MM)\n    let fy = y;\n    if (m > yeMonth) {\n      fy = y + 1;\n    }\n    let shiftedM = m - yeMonth;\n    if (shiftedM <= 0) {\n      shiftedM += 12;\n    }\n    const absM = fy * 12 + (shiftedM - 1);\n    const mStr = m < 10 ? `0${m}` : `${m}`;\n    return { label: `FY${fy}-${mStr}`, absM: absM };\n  }\n}\n\n\/**\n * \u7d76\u5bfe\u6708\u756a\u53f7\u3068\u6c7a\u7b97\u6708\u304b\u3089\u3001\u30e9\u30d9\u30eb\u6587\u5b57\u5217\u3092\u5fa9\u5143\u3059\u308b\uff08\u30c8\u30d3\u306e\u7a74\u57cb\u3081\u7528\uff09\n * @param {number} absM - Absolute Month Number\n * @param {number} yeMonth - Year End Month\n * @returns {string} Month label\n *\/\nfunction getLabelFromAbsoluteMonth(absM, yeMonth) {\n  if (yeMonth === 0) {\n    const y = Math.floor(absM \/ 12);\n    const m = (absM % 12) + 1;\n    const mStr = m < 10 ? `0${m}` : `${m}`;\n    return `${y}-${mStr}`;\n  } else {\n    const fy = Math.floor(absM \/ 12);\n    const shiftedM = (absM % 12) + 1;\n    let m = shiftedM + yeMonth;\n    if (m > 12) {\n      m -= 12;\n    }\n    const mStr = m < 10 ? `0${m}` : `${m}`;\n    return `FY${fy}-${mStr}`;\n  }\n}\n\n\n\/**\n * Parses TSV string as a two-dimensional rectangular data matrix and creates a 2D array.\n * @param {string} strTsv - The input TSV string\n * @returns {Array<Array<string>>} Rectangular 2D array\n *\/\nfunction parseAsRectangular( strTsv ){\n  const arrTsv = strTsv.split("\\n");\n  let numMinWidth   = Infinity;\n  let numMaxWidth   = 0;\n  let numBlanklines = 0;\n  \n  const parsedRows = [];\n  for( let i = 0; i < arrTsv.length; i++ ){\n    const line = arrTsv[i];\n    if( line === "" ){\n      numBlanklines++;\n      continue;\n    }\n    const arrCells = line.split("\\t");\n    const len = arrCells.length;\n    if( len < numMinWidth ){ numMinWidth = len; }\n    if( len > numMaxWidth ){ numMaxWidth = len; }\n    parsedRows.push( arrCells );\n  }\n  \n  if( numMinWidth === Infinity ){\n    numMinWidth = 0;\n  }\n  engine.log( " AutomatedTask TsvDataCheck:" + \n              " MinWidth:" + numMinWidth +\n              " MaxWidth:" + numMaxWidth +\n              " Lines:" + arrTsv.length +\n              " (BlankLines:" + numBlanklines + ")" );\n\n  for( let i = 0; i < parsedRows.length; i++ ){\n    const row = parsedRows[i];\n    while( row.length < numMaxWidth ){\n      row.push( "" );\n    }\n  }\n  return parsedRows;\n}\n\n\n\/**\n * Parses a Date or Datetime string and returns a JavaScript `Date` object as local time.\n * Timezone information in the string (such as "Z" or "+09:00") is forcefully ignored.\n * Supports various formats: "YYYYMMDD", "YYYY-MM-DD", ISO 8601, Japanese localized formats, etc.\n * * @param {string} str - The date or datetime string to parse.\n * @returns {Date} A local Date object.\n * @throws {Error} Throws an error if the string is empty or contains fewer than 2 numeric parts.\n *\/\nfunction parseAsLocalDate ( str ){ \/\/ strDateOrDatetime\n  if( str === "" ){\n    throw new Error( "\\n AutomatedTask ParseDateError:" +\n                     " String is empty \\n" );\n  }\n  const arrNumParts = str.match( \/\\d+\/g );\n  if( arrNumParts === null ){\n    throw new Error( "\\n AutomatedTask ParseDateError:" +\n                     " No numeric characters in: " + str + "\\n" );\n  }\n\n  \/\/\/ function default\n  let numYear    = 0; \/\/ limit in QBPMS: 1900 to 2100 (asof 2026-06)\n  let indexMonth = 0;\n  let numDay     = 1; \/\/ \u65e5\u4ed8\u304c\u7701\u7565\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306f\u300c1\u65e5\u300d\u306b\u30d5\u30a9\u30fc\u30eb\u30d0\u30c3\u30af (Default to 1st)\n  let numHours   = 0;\n  let numMinutes = 0;\n\n  \/\/\/ case: startsWith YYYYMMDD (8 digits)\n  if( arrNumParts[0].length === 8 ){\n    numYear      = parseInt( arrNumParts[0].slice( 0, 4 ), 10 );\n    indexMonth   = parseInt( arrNumParts[0].slice( 4, 6 ), 10 ) - 1;\n    numDay       = parseInt( arrNumParts[0].slice( 6, 8 ), 10 );\n    if (arrNumParts.length > 1) {\n      if (arrNumParts[1].length >= 4) {\n        \/\/ like "2359" or "235959Z"\n        numHours = parseInt(arrNumParts[1].slice(0, 2), 10);\n        numMinutes = parseInt(arrNumParts[1].slice(2, 4), 10);\n      } else {\n        \/\/ like "23:59" -> arrNumParts is ['...', '23', '59']\n        numHours = parseInt(arrNumParts[1], 10);\n        if (arrNumParts.length > 2) {\n          numMinutes = parseInt(arrNumParts[2], 10);\n        }\n      }\n    }\n\n  \/\/\/ case: startsWith YYYYMM (6 digits)\n  } else if ( arrNumParts[0].length === 6 ){\n    numYear      = parseInt( arrNumParts[0].slice( 0, 4 ), 10 );\n    indexMonth   = parseInt( arrNumParts[0].slice( 4, 6 ), 10 ) - 1;\n    \/\/ numDay remains 1\n\n  \/\/\/ case: not startsWith YYYYMMDD, like "2026-12-31 23:59", "2025\/06", "2025\u5e746\u6708"\n  } else {\n    \/\/ \u5fc5\u9808\u30d1\u30fc\u30c4\u3092\u300c3\u300d\u304b\u3089\u300c2\uff08\u5e74\u6708\uff09\u300d\u306b\u7de9\u548c\n    if( arrNumParts.length < 2){\n      throw new Error( "\\n AutomatedTask ParseDateError:" +\n                       " At least 2 Parts (Year, Month) are needed in: " + str + "\\n" );\n    }\n    numYear      = parseInt( arrNumParts[0], 10 );\n    indexMonth   = parseInt( arrNumParts[1], 10 ) - 1;\n    \n    \/\/ \u65e5\u4ed8\u304c\u5b58\u5728\u3059\u308b\u5834\u5408\u306e\u307f\u4e0a\u66f8\u304d\n    if (arrNumParts.length > 2) {\n      numDay       = parseInt( arrNumParts[2], 10 );\n    }\n    if (arrNumParts.length > 3) {\n      numHours = parseInt(arrNumParts[3], 10);\n    }\n    if (arrNumParts.length > 4) {\n      numMinutes = parseInt(arrNumParts[4], 10);\n    }\n  }\n\n  \/\/\/ return JavaScript `Date` object\n  const localDate = new Date(numYear, indexMonth, numDay, numHours, numMinutes);\n  localDate.setFullYear(numYear);\n  return localDate;\n}\n\n\n\n\/*\n### Sample Data 1 (date:id1, num:4, x-axis:2)\n\nID\tDATE\tSource-Channel\tRank\tTotal\nL-001\t2026\/01\/15\tJaSite\tA\t\\ 150,000\nL-002\t2026-02-10\tGmail\tB\t30,000\nL-003\t2026.02.28\tEnSite\tA\t$ 1,200\nL-004\t20260305\tJaSite\tC\t50,000\nL-005\t2026\/04\/12\tGmail\tA\t120,000\nL-006\t2026-05-20\tEnSite\tB\t85,000\nL-007\t2026\/06\/01\tJaSite\tA\t210,000\nL-008\t2026-07-15\tGmail\tA\t95,000\nL-009\t2026\/08\/22\tEnSite\tC\t\t\nL-010\t2026\/09\tJaSite\tB\t130,000\n\n### Sample Data 2\n\n\u53d6\u5f15No\t\u53d6\u5f15\u65e5\t\u62c5\u5f53\u90e8\u9580\t\u52d8\u5b9a\u79d1\u76ee\t\u91d1\u984d\uff08\u5186\uff09\t\u30a4\u30f3\u30dc\u30a4\u30b9\n1\t2026\/04\/01\t\u7ba1\u7406\u90e8\t\u6d88\u8017\u54c1\u8cbb\t5,500\t\u9069\u683c\n2\t2026\/04\/02\t\u55b6\u696d\u90e8\t\u65c5\u8cbb\u4ea4\u901a\u8cbb\t1,320\t\u9069\u683c\n3\t2026-05-15\t\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u90e8\t\u5e83\u544a\u5ba3\u4f1d\u8cbb\t55,000\t\u9069\u683c\n4\t2026\/06\/03\t\u7ba1\u7406\u90e8\t\u901a\u4fe1\u8cbb\t8,800\t\u9069\u683c\n5\t2026\/07\/05\t\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u90e8\t\u5e83\u544a\u5ba3\u4f1d\u8cbb\t110,000\t\u9069\u683c\n6\t2026-08-12\t\u55b6\u696d\u90e8\t\u65c5\u8cbb\u4ea4\u901a\u8cbb\t24,500\t\u9069\u683c\n7\t2026\/09\/01\t\u7ba1\u7406\u90e8\t\u798f\u5229\u539a\u751f\u8cbb\t12,000\t\u9069\u683c\n8\t2026\/11\/20\t\u55b6\u696d\u90e8\t\u4ea4\u969b\u8cbb\t18,000\t\u975e\u9069\u683c\n9\t2027-01-06 12:30\t\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u90e8\t\u5e83\u544a\u5ba3\u4f1d\u8cbb\t33,000\t\u9069\u683c\n10\t2027\/02\/15\t\u7ba1\u7406\u90e8\t\u6d88\u8017\u54c1\u8cbb\t4,200\t\u9069\u683c\n\n\n### NOTES-en\n\n* When a case reaches this [Automated Step], the TSV pivot table creation process is automatically executed.\n    * The first row of the input TSV is recognized as the header row.\n* The input TSV string is parsed as a simple tab-separated values string.\n    * Double quotes and other specific characters within the TSV string are retained as is.\n    * Blank lines within the TSV string are ignored.\n    * For rows lacking the expected number of cells, empty string ("") cells are automatically appended.\n    * The number of rows in the input\/output TSV string can be stored as Case Data.\n* The date column used as the Y-axis aggregation key is specified by its column ID.\n    * It does not necessarily have to be Column A (id=0).\n    * Set this to "1" if Column B (id=1) is to serve as the aggregation key.\n* The column used as the X-axis aggregation key is specified by its column ID.\n    * If the computation time becomes excessive (eg, due to an extremely large number of columns), a timeout may occur.\n    * The columns on the X-axis are dynamically sorted in descending order of occurrence frequency or total value.\n\n\n### NOTES-ja\n\n* \u6848\u4ef6\uff08\u30b1\u30fc\u30b9\uff09\u304c\u3053\u306e\uff3b\u81ea\u52d5\u5de5\u7a0b\uff3d\u306b\u5230\u9054\u3059\u308b\u3068\u3001Pivot\u751f\u6210\u51e6\u7406\u304c\u81ea\u52d5\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002\n    * \u5165\u529bTSV\u306e1\u884c\u76ee\u306f\u3001\u30d8\u30c3\u30c0\u30fc\u884c\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u307e\u3059\u3002\n* \u5165\u529bTSV\u6587\u5b57\u5217\u306f\u3001\u30b7\u30f3\u30d7\u30eb\u306a\u30bf\u30d6\u533a\u5207\u308a\u6587\u5b57\u5217\u3068\u3057\u3066\u30d1\u30fc\u30b9\u3055\u308c\u307e\u3059\u3002\n    * TSV\u6587\u5b57\u5217\u5185\u306e\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u7b49\u3082\u3001\u305d\u306e\u307e\u307e\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002\n    * TSV\u6587\u5b57\u5217\u5185\u306e\u7a7a\u884c\u306f\u3001\u7121\u8996\u3055\u308c\u307e\u3059\u3002\n    * TSV\u6587\u5b57\u5217\u5185\u3067\u30bb\u30eb\u6570\u306e\u8db3\u308a\u306a\u3044\u884c\u306f\u3001\u7a7a\u6587\u5b57\uff08""\uff09\u306e\u30bb\u30eb\u304c\u81ea\u52d5\u7684\u306b\u88dc\u5b8c\u3055\u308c\u307e\u3059\u3002\n    * \u5165\u51fa\u529bTSV\u306e\u884c\u6570\u306f\u3001\u30b1\u30fc\u30b9\u30c7\u30fc\u30bf\u3068\u3057\u3066\u683c\u7d0d\u53ef\u80fd\u3067\u3059\u3002\n* Y\u96c6\u8a08\u30ad\u30fc\u3068\u306a\u308b\u65e5\u4ed8\u5217\u306fID\u3067\u6307\u5b9a\u3057\u307e\u3059\n    * \u5fc5\u305a\u3057\u3082A\u5217\uff08id=0\uff09\u3067\u306a\u304f\u3066\u3082\u69cb\u3044\u307e\u305b\u3093\u3002\n    * B\u5217\uff08id=1\uff09\u304c\u96c6\u8a08\u30ad\u30fc\u3068\u306a\u308b\u5834\u5408\u3001"1" \u3068\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002\n* X\u96c6\u8a08\u30ad\u30fc\u3068\u306a\u308b\u5217\u306fID\u3067\u6307\u5b9a\u3057\u307e\u3059\n    * \u8a08\u7b97\u6642\u9593\u304c\u5927\u304d\u304f\u306a\u308b\uff08\u6975\u7aef\u306b\u5217\u6570\u304c\u591a\u3044\u306a\u3069\uff09\u3068\u3001\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\n    * \u203bX\u8ef8\u306e\u5217\u306f\u3001\u51fa\u73fe\u983b\u5ea6\u307e\u305f\u306f\u5408\u8a08\u5024\u306e\u964d\u9806\u3067\u52d5\u7684\u306b\u4e26\u3073\u66ff\u308f\u308a\u307e\u3059\u3002\n\n\n### APPENDIX-en\n* The default format for the month label is `2026-04`.\n    * By setting the Year-End (YE) Month, you can switch to the FY format (Fiscal Year basis \/ End-Year style).\n        * Note) End-Year style: FY2027 = 2026\/04\/01 to 2027\/03\/31\n        * e.g.: "3"; `2026-04` \u2192 `FY2027-04`\n        * e.g.: "12"; `2026-04` \u2192 `FY2026-04`\u3000(Since Jan-Mar is Q1)\n* Cells in the specified numeric columns are parsed as numbers as much as possible. *(Excluding the first header row)*\n    * Any characters other than periods (`.`), minus signs (`-`), and digits (`0-9`) are stripped out.\n        * such as commas acting as digit separators or currency symbols\n    * The resulting string is evaluated using `Number()`.\n    * If parsing fails, the value is treated as `0`.\n    * e.g.: `$ 1,500.50 usd` \u21d2 `1500.5`\n* If there are missing periods (gaps) between the oldest and newest months in the input data, they are automatically filled with `0`.\n    * Both the row count and the numeric sums will be output as `0`.\n    * e.g.: If data only exists for `2026-04` and `2026-06`, the missing `2026-05` will automatically be generated and output with a count of `0`.\n\n\n### APPENDIX-ja\n* \u6708\u6b21\u30e9\u30d9\u30eb\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u306f `2026-04` \u3067\u3059\u3002\n    * \u6c7a\u7b97\u6708\u3092\u30bb\u30c3\u30c8\u3059\u308c\u3070FY\u65b9\u5f0f\uff08\u4f1a\u8a08\u5e74\u5ea6\u30d9\u30fc\u30b9\uff0f\u7d42\u4e86\u5e74\u65b9\u5f0f\uff09\u306b\u5909\u66f4\u53ef\u80fd\u3067\u3059\u3002\n        * \u203b \u7d42\u4e86\u5e74\u65b9\u5f0f\uff1a FY2027 = 2026\/04\/01 \uff5e 2027\/03\/31\n        * \u4f8b: "3"; `2026-04` \u2192 `FY2027-04`\n        * \u4f8b: "12"; `2026-04` \u2192 `FY2026-04`\n* \u6570\u5024\u5217\u3068\u3057\u3066\u6307\u5b9a\u3055\u308c\u305f\u5217\u306e\u5404\u30c7\u30fc\u30bf\u306f\u3001\u53ef\u80fd\u306a\u9650\u308a\u6570\u5024\u3068\u3057\u3066\u89e3\u6790\u3055\u308c\u307e\u3059\u3002\u203b\u5148\u982d1\u884c\u76ee\uff08\u30d8\u30c3\u30c0\u30fc\u884c\uff09\u3092\u9664\u304f\n    * \u300c\u30d4\u30ea\u30aa\u30c9(.)\u300d\u300c\u30de\u30a4\u30ca\u30b9\u8a18\u53f7(-)\u300d\u300c\u6570\u5b57(0\uff5e9)\u300d\u4ee5\u5916\u306e\u6587\u5b57\u304c\u5b58\u5728\u3059\u308b\u5834\u5408\u306f\u3001\u305d\u308c\u3089\u304c\u9664\u53bb\u3055\u308c\u305f\u4e0a\u3067\u89e3\u6790\u3055\u308c\u307e\u3059\u3002\n        * \u6841\u533a\u5207\u308a\u30ab\u30f3\u30de\u3084\u901a\u8ca8\u8a18\u53f7\u306a\u3069\n    * \u9664\u53bb\u5f8c\u306e\u6587\u5b57\u5217\u306f `Number()` \u306b\u3088\u3063\u3066\u6570\u5024\u5316\u3055\u308c\u307e\u3059\u3002\n    * \u89e3\u6790\u306b\u5931\u6557\u3057\u305f\u5834\u5408\u306f `0` \u3068\u3057\u3066\u52a0\u7b97\u3055\u308c\u307e\u3059\u3002\n    * \u4f8b: `$ 1,500.50 usd` \u21d2 `1500.5`\n* \u5165\u529b\u30c7\u30fc\u30bf\u306b\u304a\u3051\u308b\u300c\u6700\u3082\u53e4\u3044\u6708\u300d\u304b\u3089\u300c\u6700\u3082\u65b0\u3057\u3044\u6708\u300d\u307e\u3067\u306e\u9593\u306b\u3001\u30c7\u30fc\u30bf\u304c\u5b58\u5728\u3057\u306a\u3044\u6708\uff08\u30c8\u30d3\uff09\u304c\u3042\u308b\u5834\u5408\u3001\u305d\u306e\u6708\u306f\u81ea\u52d5\u7684\u306b\u7a74\u57cb\u3081\uff08\u88dc\u5b8c\uff09\u3055\u308c\u307e\u3059\u3002\n    * \u30ab\u30a6\u30f3\u30c8\u304a\u3088\u3073\u6570\u5024\u5217\u306e\u5408\u8a08\u306f `0` \u3068\u3057\u3066\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\n    * \u4f8b: `2026-04` \u3068 `2026-06` \u306e\u30c7\u30fc\u30bf\u306e\u307f\u304c\u5b58\u5728\u3059\u308b\u5834\u5408\u3001\u9593\u306e `2026-05` \u306f\u30ab\u30a6\u30f3\u30c8 `0` \u306e\u884c\u3068\u3057\u3066\u81ea\u52d5\u751f\u6210\u3055\u308c\u307e\u3059\u3002\n*\/\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n