{"id":168912,"date":"2025-01-15T14:56:33","date_gmt":"2025-01-15T05:56:33","guid":{"rendered":"https:\/\/support.questetra.com\/?p=168912"},"modified":"2026-06-05T16:22:59","modified_gmt":"2026-06-05T07:22:59","slug":"service-task-csv-update","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-csv-update\/","title":{"rendered":"CSV \u30c7\u30fc\u30bf\u66f4\u65b0"},"content":{"rendered":"\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"58\" data-attachment-id=\"113157\" data-permalink=\"https:\/\/support.questetra.com\/ja\/developer-blog\/how-to-use-timer-start-event\/attachment\/advanced-banner-new-ja\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-ja.png?fit=1199%2C68&amp;ssl=1\" data-orig-size=\"1199,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=\"advanced-banner-new-ja\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-ja.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-ja.png?resize=1024%2C58&#038;ssl=1\" alt=\"\" class=\"wp-image-113157\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-ja.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-ja.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-ja.png?resize=768%2C44&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-ja.png?w=1199&amp;ssl=1 1199w\" 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\n<h4 id=\"csv-\u30c7\u30fc\u30bf\u66f4\u65b0\" class=\"wp-block-heading has-background\" style=\"background-color:#ccffcc;margin-top:var(--wp--preset--spacing--30);margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><strong>CSV \u30c7\u30fc\u30bf\u66f4\u65b0<\/strong><\/h4>\n\n\n\n<p class=\"has-text-align-right has-border-color has-product-main-border-color has-white-color has-product-main-background-color has-text-color has-background has-link-color has-small-font-size mt-0 pt-0 wp-block-paragraph\" style=\"border-width:2px;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><a href=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-csv-update\/\">Update CSV Data<\/a><\/p>\n\n\n\n<p class=\"has-border-color has-product-main-border-color has-text-color has-white-background-color has-background has-link-color mt-0 pt-0 wp-block-paragraph\" style=\"border-width:2px;margin-top:0;margin-right:0;margin-bottom:var(--wp--preset--spacing--30);margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--20)\">\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u5165\u529b\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092 RDB \u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u6271\u3044\u3001\u30af\u30a8\u30ea\uff08SQL\uff09\u306b\u3088\u308a\u30c7\u30fc\u30bf\u3092\u64cd\u4f5c\u3057\u307e\u3059\u3002\u30af\u30a8\u30ea\u5b9f\u884c\u7d50\u679c\u306f\u6307\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3055\u308c\u307e\u3059\u30022\u3064\u306e\u30c7\u30fc\u30bf\u3092\u7d50\u5408\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<nav aria-label=\"\u76ee\u6b21\" class=\"wp-block-table-of-contents\"><ol><li><a class=\"wp-block-table-of-contents__entry\" href=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-csv-update\/#\u5165\u529b\u30c7\u30fc\u30bf\">\u5165\u529b\u30c7\u30fc\u30bf<\/a><\/li><li><a class=\"wp-block-table-of-contents__entry\" href=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-csv-update\/#\u30af\u30a8\u30ea\">\u30af\u30a8\u30ea<\/a><\/li><li><a class=\"wp-block-table-of-contents__entry\" href=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-csv-update\/#\u4fdd\u5b58\u8a2d\u5b9a\">\u4fdd\u5b58\u8a2d\u5b9a<\/a><\/li><li><a class=\"wp-block-table-of-contents__entry\" href=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-csv-update\/#\u30af\u30a8\u30ea\u306e\u4f8b\">\u30af\u30a8\u30ea\u306e\u4f8b<\/a><\/li><\/ol><\/nav>\n\n\n\n<h2 id=\"\u5165\u529b\u30c7\u30fc\u30bf\" class=\"wp-block-heading\">\u5165\u529b\u30c7\u30fc\u30bf<\/h2>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title has-background\" style=\"background-color:#e6f0f7\">Basic Configs<\/summary><div class=\"wp-block-coblocks-accordion-item__content\" style=\"border-color:#e6f0f7\">\n<dl style=\"0 0 -0.7em 0\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\"><\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">\u5de5\u7a0b\u540d<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #C3C3C3;\"><\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">\u30e1\u30e2<\/dd>\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title has-background\" style=\"background-color:#e6f0f7\">Configs: \u5165\u529b\u30c7\u30fc\u30bf<\/summary><div class=\"wp-block-coblocks-accordion-item__content\" style=\"border-color:#e6f0f7\">\n<dl style=\"0 0 -0.7em 0\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C1: \u30c7\u30fc\u30bf\u304c\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u9805\u76ee1<span style=\"color:#990000;\"> *<\/span><\/dd>\n<div style=\"margin:4px 0px 1em; border:1px dotted #aaa; padding:4px 0 0 4px\" title=\"Data 1\"><dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C1a: \u30c7\u30fc\u30bf\u5f62\u5f0f<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 2em\">CSV \/ TSV<\/dd><dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 2em\">\u30d8\u30c3\u30c0\u306e\u6709\u7121<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C1b: \u30af\u30a8\u30ea\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u969b\u306e\u30c6\u30fc\u30d6\u30eb\u540d<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C1c: \u30c6\u30fc\u30d6\u30eb\u306b ID \u30ab\u30e9\u30e0\u3092\u8ffd\u52a0\u3059\u308b (1, 2, 3 &#8230; \u3068\u884c\u756a\u53f7\u304c\u81ea\u52d5\u7684\u306b\u4ed8\u4e0e\u3055\u308c\u307e\u3059)<\/dd>\n<\/div>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C2: \u30c7\u30fc\u30bf\u304c\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u9805\u76ee2<\/dd>\n<div style=\"margin:4px 0px 1em; border:1px dotted #aaa; padding:4px 0 0 4px\" title=\"Data 2\"><dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C2a: \u30c7\u30fc\u30bf\u5f62\u5f0f<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 2em\">CSV \/ TSV<\/dd><dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 2em\">\u30d8\u30c3\u30c0\u306e\u6709\u7121<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C2b: \u30af\u30a8\u30ea\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u969b\u306e\u30c6\u30fc\u30d6\u30eb\u540d<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C2c: \u30c6\u30fc\u30d6\u30eb\u306b ID \u30ab\u30e9\u30e0\u3092\u8ffd\u52a0\u3059\u308b (1, 2, 3 &#8230; \u3068\u884c\u756a\u53f7\u304c\u81ea\u52d5\u7684\u306b\u4ed8\u4e0e\u3055\u308c\u307e\u3059)<\/dd>\n<\/div>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<h3 id=\"capture\" class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span>Capture<\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"782\" height=\"630\" data-attachment-id=\"179990\" data-permalink=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-csv-update\/attachment\/csv-update-input-data-ja\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-ja.png?fit=1227%2C989&amp;ssl=1\" data-orig-size=\"1227,989\" 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=\"csv-update-input-data-ja\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-ja.png?fit=782%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-ja.png?resize=782%2C630&#038;ssl=1\" alt=\"\" class=\"has-border-color has-ast-global-color-3-border-color wp-image-179990\" style=\"border-width:3px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-ja.png?resize=782%2C630&amp;ssl=1 782w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-ja.png?resize=391%2C315&amp;ssl=1 391w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-ja.png?resize=768%2C619&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-ja.png?resize=1200%2C967&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-ja.png?w=1227&amp;ssl=1 1227w\" sizes=\"auto, (max-width: 782px) 100vw, 782px\" \/><\/figure>\n\n\n\n<h3 id=\"notes\" class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span>Notes<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4ee5\u4e0b\u306e\u30c7\u30fc\u30bf\u3092\u5bfe\u8c61\u306b\u51e6\u7406\u304c\u884c\u308f\u308c\u307e\u3059\n<ul class=\"wp-block-list\">\n<li>\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\n<ul class=\"wp-block-list\">\n<li>\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u306f\u3001\u6587\u5b57\u578b\uff08\u8907\u6570\u884c\uff09\u3068\u6587\u5b57\u578b\uff08\u5358\u4e00\u884c\uff09\u306e\u3044\u305a\u308c\u3067\u3082\u51e6\u7406\u3067\u304d\u307e\u3059<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u306f RDB \u306e\u30c6\u30fc\u30d6\u30eb\u3068\u307f\u306a\u3055\u308c\u3001H2 Database \u306e\u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059<\/li>\n\n\n\n<li>\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u30af\u30a8\u30ea\uff08SQL\uff09\u3092\u767a\u884c\u3057\u3001\u7d50\u679c\u304c\u6307\u5b9a\u306e\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3055\u308c\u307e\u3059<\/li>\n\n\n\n<li>\u672c\u5de5\u7a0b\u306f\u3001\u6587\u5b57\u5217\u30c7\u30fc\u30bf\u3092\u6570\u5024\u3078\u5909\u63db\u3059\u308b\u51e6\u7406\u306b\u3082\u5229\u7528\u3067\u304d\u307e\u3059\uff08\u73fe\u884c\u306e\uff3b\u30c7\u30fc\u30bf\u66f4\u65b0\uff3d\u5de5\u7a0b\u3067\u306f\u300c\u6587\u5b57\u578b\u304b\u3089\u6570\u5024\u578b\u300d\u3078\u306e\u5909\u63db\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u305b\u3093\uff09<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u30c6\u30fc\u30d6\u30eb\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\n<ul class=\"wp-block-list\">\n<li>\u96c6\u8a08\u884c\u3092\u9664\u304d\u3001CSV \u306e\u5024\u304c\u305d\u306e\u307e\u307eDB\u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u53d6\u308a\u8fbc\u307e\u308c\u307e\u3059<\/li>\n\n\n\n<li>\u30ab\u30e9\u30e0\u540d\u306f\u30c6\u30fc\u30d6\u30eb\u9805\u76ee\u540d\u3067\u3059\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3067\u306f\u306a\u3044\u3053\u3068\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\uff09<\/li>\n\n\n\n<li>\u5168\u30ab\u30e9\u30e0\u306f varchar \u578b\u3068\u3057\u3066\u4fdd\u5b58\u3055\u308c\u307e\u3059<\/li>\n\n\n\n<li>DB\u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u53d6\u308a\u8fbc\u307e\u308c\u308b\u969b\u306e\u30c7\u30fc\u30bf\u5f62\u5f0f\n<ul class=\"wp-block-list\">\n<li>\u6587\u5b57\u30c6\u30fc\u30d6\u30eb\u9805\u76ee\uff1a\u305d\u306e\u307e\u307e\u4fdd\u5b58<\/li>\n\n\n\n<li>\u6570\u5024\u30c6\u30fc\u30d6\u30eb\u9805\u76ee\uff1a\u5c0f\u6570\u70b9\u30d4\u30ea\u30aa\u30c9\u3001\u6841\u533a\u5207\u308a\u6587\u5b57\u7121\u3057\u306e\u30c6\u30ad\u30b9\u30c8\u3068\u3057\u3066\u4fdd\u5b58<\/li>\n\n\n\n<li>\u65e5\u4ed8\u30c6\u30fc\u30d6\u30eb\u9805\u76ee\uff1ayyyy-MM-dd \u5f62\u5f0f\u306e\u30c6\u30ad\u30b9\u30c8\u3068\u3057\u3066\u4fdd\u5b58<\/li>\n\n\n\n<li>\u9078\u629e\u30c6\u30fc\u30d6\u30eb\u9805\u76ee\uff1a\u300c\u9078\u629e\u80a2\u306e\u5024\u300d\u3092\u30c6\u30fc\u30d6\u30eb\u306b\u4fdd\u5b58<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u306e1\u884c\u76ee\u306b\u3064\u3044\u3066\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u540d\u3068\u307f\u306a\u3059\uff08\u30d8\u30c3\u30c0\u3042\u308a\uff09\u304b\u3001\u30c7\u30fc\u30bf\u3068\u307f\u306a\u3059\uff08\u30d8\u30c3\u30c0\u306a\u3057\uff09\u304b\u3092\u9078\u629e\u3067\u304d\u307e\u3059\n<ul class=\"wp-block-list\">\n<li>\u6587\u5b57\u578b\uff08\u5358\u4e00\u884c\uff09\u3092\u5bfe\u8c61\u3068\u3059\u308b\u5834\u5408\u306f\u3001\u30c7\u30fc\u30bf\u3068\u307f\u306a\u3059\uff08\u30d8\u30c3\u30c0\u306a\u3057\uff09\u3092\u6307\u5b9a\u3057\u307e\u3059<\/li>\n\n\n\n<li>\u30ab\u30e9\u30e0\u540d\u306f\u30011\u6587\u5b57\u4ee5\u4e0a64\u6587\u5b57\u4ee5\u4e0b\u3067\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n\n\n\n<li>\u30ab\u30e9\u30e0\u540d\u304c\u7a7a\u3001\u307e\u305f\u306f64\u6587\u5b57\u3092\u8d85\u3048\u308b\u30ab\u30e9\u30e0\u304c\u3042\u308b\u5834\u5408\u3001\u51e6\u7406\u306b\u5931\u6557\u3057\u307e\u3059<\/li>\n\n\n\n<li>\u30ab\u30e9\u30e0\u540d\u306b\u91cd\u8907\u304c\u3042\u308b\u3068\u51e6\u7406\u306b\u5931\u6557\u3057\u307e\u3059<\/li>\n\n\n\n<li>\u5217\u306e\u578b\u306f\u5168\u3066 varchar \u3068\u3057\u3066\u6271\u308f\u308c\u3001integer, date \u306a\u3069\u3068\u3057\u3066\u6271\u3046\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093<\/li>\n\n\n\n<li>\u30ab\u30e9\u30e0\u540d\u884c\u306e\u5217\u6570\u3068\u30c7\u30fc\u30bf\u884c\u306e\u5217\u6570\u304c\u4e00\u81f4\u3057\u306a\u3044\u5834\u5408\u3001\u81ea\u52d5\u3067\u88dc\u5b8c\u3055\u308c\u307e\u3059\n<ul class=\"wp-block-list\">\n<li>\u30c7\u30fc\u30bf\u884c\u306e\u5217\u6570\u304c\u30ab\u30e9\u30e0\u540d\u884c\u3088\u308a\u591a\u3051\u308c\u3070\u3001\u4f8b\u3048\u307010\u756a\u76ee\uff081\u59cb\u307e\u308a\uff09\u306b\u30ab\u30e9\u30e0\u540d\u300ccol10\u300d\u306e\u5217\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059<\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u884c\u306e\u5217\u6570\u304c\u30ab\u30e9\u30e0\u540d\u884c\u3088\u308a\u5c11\u306a\u3044\u5834\u5408\u3001\u30c7\u30fc\u30bf\u884c\u306e\u8db3\u308a\u306a\u3044\u5206\u306e\u5217\u306b\u306f null \u306e\u30c7\u30fc\u30bf\u304c\u3042\u308b\u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u5165\u529b\u3055\u308c\u3066\u3044\u308b TSV\/CSV \u306b ID \u30ab\u30e9\u30e0\u3092\u81ea\u52d5\u8ffd\u52a0\u3067\u304d\u307e\u3059\n<ul class=\"wp-block-list\">\n<li>\u30c7\u30fc\u30bf\u306e\u884c\u756a\u53f7\u3092\u793a\u3059 ID \u304c\u81ea\u52d5\u7684\u306b\u4ed8\u4e0e\u3055\u308c\u307e\u3059<\/li>\n\n\n\n<li>CSV\/TSV \u30c7\u30fc\u30bf\u306b ID \u30ab\u30e9\u30e0\u304c\u5b58\u5728\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u51e6\u7406\u306b\u5931\u6557\u3057\u307e\u3059<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\uff3bC1: \u30c7\u30fc\u30bf\u304c\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u9805\u76ee1\uff3d\u3092\u6307\u5b9a\u3059\u308b\u3068\u3001\uff3bC1a: \u30c7\u30fc\u30bf\u5f62\u5f0f\uff3d\/\uff3bC1b: \u30af\u30a8\u30ea\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u969b\u306e\u30c6\u30fc\u30d6\u30eb\u540d\uff3d\/\uff3bC1c: \u30c6\u30fc\u30d6\u30eb\u306b ID \u30ab\u30e9\u30e0\u3092\u8ffd\u52a0\u3059\u308b (1, 2, 3 &#8230; \u3068\u884c\u756a\u53f7\u304c\u81ea\u52d5\u7684\u306b\u4ed8\u4e0e\u3055\u308c\u307e\u3059)\uff3d \u306e\u8a2d\u5b9a\u9805\u76ee\u304c\u5c55\u958b\u3055\u308c\u307e\u3059\uff08C2\u3082\u540c\u69d8\uff09<\/li>\n\n\n\n<li>\uff3bC2: \u30c7\u30fc\u30bf\u304c\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u9805\u76ee2\uff3d\u30672\u3064\u76ee\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u6307\u5b9a\u3059\u308b\u3068\u30012\u3064\u306e\u30c7\u30fc\u30bf\uff08\u30c6\u30fc\u30d6\u30eb\uff09\u3092\u7d50\u5408\u3059\u308b\u30af\u30a8\u30ea\uff08SQL\uff09\u3092\u767a\u884c\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059<\/li>\n<\/ul>\n\n\n\n<h2 id=\"\u30af\u30a8\u30ea\" class=\"wp-block-heading\">\u30af\u30a8\u30ea<\/h2>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title has-background\" style=\"background-color:#e6f0f7\">Configs: \u30af\u30a8\u30ea<\/summary><div class=\"wp-block-coblocks-accordion-item__content\" style=\"border-color:#e6f0f7\">\n<dl style=\"0 0 -0.7em 0\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C3: \u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u767a\u884c\u3059\u308b\u30af\u30a8\u30ea<span style=\"color:#990000;\"> *<\/span><\/dd>\n\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<h3 id=\"capture\" class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span>Capture<\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"630\" data-attachment-id=\"179992\" data-permalink=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-csv-update\/attachment\/csv-update-query-ja\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-ja.png?fit=1224%2C981&amp;ssl=1\" data-orig-size=\"1224,981\" 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=\"csv-update-query-ja\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-ja.png?fit=786%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-ja.png?resize=786%2C630&#038;ssl=1\" alt=\"\" class=\"has-border-color has-ast-global-color-3-border-color wp-image-179992\" style=\"border-width:3px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-ja.png?resize=786%2C630&amp;ssl=1 786w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-ja.png?resize=393%2C315&amp;ssl=1 393w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-ja.png?resize=768%2C616&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-ja.png?resize=1200%2C962&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-ja.png?w=1224&amp;ssl=1 1224w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><\/figure>\n\n\n\n<h3 id=\"notes\" class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span>Notes<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>H2 Database \u306b\u5bfe\u5fdc\u3059\u308b SQL \u3067\u8a18\u8ff0\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n\n\n\n<li>\uff3bC3: \u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u767a\u884c\u3059\u308b\u30af\u30a8\u30ea\uff3d\u306b\u6307\u5b9a\u3059\u308b\u30af\u30a8\u30ea\uff08SQL\uff09\u306b\u306f\u3001\u6700\u59272000\u6587\u5b57\u306e\u5236\u9650\u304c\u3042\u308a\u307e\u3059\n<ul class=\"wp-block-list\">\n<li>\u30af\u30a8\u30ea\uff08SQL\uff09\u306b\u6307\u5b9a\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u540d\/\u30ab\u30e9\u30e0\u540d\u306f\u3001\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c8\uff08\u201d\uff09\u3067\u56f2\u307f\u307e\u3059<\/li>\n\n\n\n<li>\u30af\u30a8\u30ea\u306b\u542b\u3093\u3067\u306f\u3044\u3051\u306a\u3044\u7981\u6b62\u8a9e\u304c\u3042\u308a\u307e\u3059\n<ul class=\"wp-block-list\">\n<li>\u30d5\u30a1\u30a4\u30eb\u30b7\u30b9\u30c6\u30e0\u306b\u95a2\u9023\u3057\u305f\u95a2\u6570\u306e\u540d\u524d\u306a\u3069<\/li>\n\n\n\n<li>\u30c6\u30fc\u30d6\u30eb\u540d\u3084\u30ab\u30e9\u30e0\u540d\u306b\u3082\u542b\u3081\u307e\u305b\u3093<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\u5165\u529b\u8a2d\u5b9a\u3067\uff3b\u30d8\u30c3\u30c0\u306a\u3057\uff3d\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u9078\u629e\u3057\u305f\u5834\u5408\u3001\u30af\u30a8\u30ea\uff08SQL\uff09\u3067\u306e\u5217\u306e\u6307\u5b9a\u306f \u201ccol1\u201d \u201ccol2\u201d \u3067\u884c\u3044\u307e\u3059<\/li>\n\n\n\n<li>\u30da\u30fc\u30b8\u4e0b\u90e8\u306e\u300c<a href=\"#\u30af\u30a8\u30ea\u306e\u4f8b\">\u30af\u30a8\u30ea\u306e\u4f8b<\/a>\u300d\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044<\/li>\n<\/ul>\n\n\n\n<h2 id=\"\u4fdd\u5b58\u8a2d\u5b9a\" class=\"wp-block-heading\">\u4fdd\u5b58\u8a2d\u5b9a<\/h2>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title has-background\" style=\"background-color:#e6f0f7\">Configs: \u4fdd\u5b58\u8a2d\u5b9a<\/summary><div class=\"wp-block-coblocks-accordion-item__content\" style=\"border-color:#e6f0f7\">\n<dl style=\"0 0 -0.7em 0\">\n\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C4: \u30af\u30a8\u30ea\u7d50\u679c\u306e\u4fdd\u5b58\u65b9\u6cd5<span style=\"color:#990000;\"> *<\/span><\/dd>\n\n<div style=\"margin:4px 0px 1em; border:1px dotted #aaa; padding:4px 0 0 4px\" title=\"Data 1\"><dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">\u30c6\u30fc\u30d6\u30eb\u5168\u4f53\u3092\uff11\u3064\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3059\u308b<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 2em\">C4a: \u30af\u30a8\u30ea\u7d50\u679c\u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 2em\">C4b: \u4fdd\u5b58\u3059\u308b\u969b\u306e\u30c7\u30fc\u30bf\u5f62\u5f0f<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 3em\">CSV \/ TSV<\/dd><dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 3em\">\u30d8\u30c3\u30c0\u306e\u6709\u7121<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 2em\">C4c: \u30ab\u30e9\u30e0\u540d\u3068\u30c7\u30fc\u30bf\u3092\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c8\u3067\u56f2\u3080<\/dd>\n<\/div>\n  <div style=\"margin:4px 0px 1em; border:1px dotted #aaa; padding:4px 0 0 4px\" title=\"Data 2\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">\u5404\u30ab\u30e9\u30e0\u306e\u5024\u3092\u6539\u884c\u533a\u5207\u308a\u3067\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3059\u308b<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 2em\">C4a: \u30af\u30a8\u30ea\u7d50\u679c\u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee<\/dd>\n  <\/div>\n  <div style=\"margin:4px 0px 1em; border:1px dotted #aaa; padding:4px 0 0 4px\" title=\"Data 3\">\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">\u5404\u30bb\u30eb\u306e\u5024\u3092\u5225\u3005\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3059\u308b<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">&nbsp;<\/dt><dd style=\"margin: -0.5em 0 0.1em 2em\">C4a: \u30af\u30a8\u30ea\u7d50\u679c\u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee<\/dd>\n<\/div>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<h3 id=\"capture\" class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span>Capture<\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"630\" data-attachment-id=\"179995\" data-permalink=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-csv-update\/attachment\/csv-update-save-settings-ja\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-ja.png?fit=1219%2C981&amp;ssl=1\" data-orig-size=\"1219,981\" 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=\"csv-update-save-settings-ja\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-ja.png?fit=783%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-ja.png?resize=783%2C630&#038;ssl=1\" alt=\"\" class=\"has-border-color has-ast-global-color-3-border-color wp-image-179995\" style=\"border-width:3px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-ja.png?resize=783%2C630&amp;ssl=1 783w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-ja.png?resize=391%2C315&amp;ssl=1 391w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-ja.png?resize=768%2C618&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-ja.png?resize=1200%2C966&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-ja.png?w=1219&amp;ssl=1 1219w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/figure>\n\n\n\n<h3 id=\"notes\" class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span>Notes<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u300cC4\uff1a\u30af\u30a8\u30ea\u7d50\u679c\u306e\u4fdd\u5b58\u65b9\u6cd5\u300d\u3067\u306f\u3001\u6b21\u306e\u4e09\u3064\u306e\u9078\u629e\u80a2\u304c\u3042\u308a\u307e\u3059\n<ul class=\"wp-block-list\">\n<li><strong>\uff3b\u30c6\u30fc\u30d6\u30eb\u5168\u4f53\u3092 CSV \/ TSV \u5f62\u5f0f\u30671\u3064\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3059\u308b\uff3d<\/strong>\n<ul class=\"wp-block-list\">\n<li>\uff3bC4a: \u30af\u30a8\u30ea\u7d50\u679c\u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\uff3d\u306b C1 \u3068\u540c\u3058\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u6307\u5b9a\u3059\u308b\u3068\u3001\u4e0a\u66f8\u304d\u4fdd\u5b58\u306b\u306a\u308a\u307e\u3059<\/li>\n\n\n\n<li>\uff3bC4a: \u30af\u30a8\u30ea\u7d50\u679c\u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\uff3d\u3067\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u6307\u5b9a\u3059\u308b\u3068 \uff3bC4b: \u4fdd\u5b58\u3059\u308b\u969b\u306e\u30c7\u30fc\u30bf\u5f62\u5f0f\uff3d \/ \uff3bC4c: \u30ab\u30e9\u30e0\u540d\u3068\u30c7\u30fc\u30bf\u3092\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c8\u3067\u56f2\u3080\uff3d\u306e\u8a2d\u5b9a\u9805\u76ee\u304c\u5c55\u958b\u3055\u308c\u307e\u3059\n<ul class=\"wp-block-list\">\n<li>\uff3bC4b: \u4fdd\u5b58\u3059\u308b\u969b\u306e\u30c7\u30fc\u30bf\u5f62\u5f0f\uff3d\u306b CSV \/ TSV \u5f62\u5f0f\u3092\u9078\u629e\u3067\u304d\u307e\u3059\u3001 \u30d8\u30c3\u30c0\u306e\u6709\u7121\u3082\u9078\u629e\u3067\u304d\u307e\u3059\n<ul class=\"wp-block-list\">\n<li>\u5165\u529b\u8a2d\u5b9a\u3067\uff3b\u30d8\u30c3\u30c0\u306a\u3057\uff3d\u3092\u9078\u629e\u3057\u305f\u30c7\u30fc\u30bf\u3092\u3001\u30d8\u30c3\u30c0\u3092\u4ed8\u3051\u305f\u30c6\u30fc\u30d6\u30eb\uff08CSV\/TSV\uff09\u3078\u3068\u5909\u63db\u3067\u304d\u307e\u3059<\/li>\n\n\n\n<li>\u5fdc\u7528\u4f8b\u3068\u3057\u3066\u3001\u8907\u6570\u884c\u6587\u5b57\u5217\u9593\u306e\u5909\u63db\u306b\u3082\u6709\u52b9\u3067\u3059<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\uff3bC4c: \u30ab\u30e9\u30e0\u540d\u3068\u30c7\u30fc\u30bf\u3092\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c8\u3067\u56f2\u3080\uff3d\u3067\u306f\u3001\u30af\u30a8\u30ea\u7d50\u679c\u3092\u4fdd\u5b58\u3059\u308b CSV \/ TSV \u30c7\u30fc\u30bf\u306b\u3066\u3001\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c8\u306e\u6709\u7121\u3092\u30aa\u30d7\u30b7\u30e7\u30f3\u6307\u5b9a\u3067\u304d\u307e\u3059<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>\uff3bC4a: \u30af\u30a8\u30ea\u7d50\u679c\u3092\u4fdd\u5b58\u3059\u308b\u30c7\u30fc\u30bf\u9805\u76ee\uff3d\u3067\u30c6\u30fc\u30d6\u30eb\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\n<ul class=\"wp-block-list\">\n<li>\u30af\u30a8\u30ea\u7d50\u679c\u306e\u30ab\u30e9\u30e0\u540d\u3068\u30c6\u30fc\u30d6\u30eb\u9805\u76ee\u540d\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3067\u306f\u306a\u3044\uff09\u304c\u4e00\u81f4\u3057\u3066\u3044\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\n<ul class=\"wp-block-list\">\n<li>SQL \u7d50\u679c\u306e\u30ab\u30e9\u30e0\u306e\u4e26\u3073\u9806\u304c\u7570\u306a\u3063\u3066\u3044\u3066\u3082\u3001\u5bfe\u5fdc\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u9805\u76ee\u306b\u5024\u304c\u4fdd\u5b58\u3055\u308c\u307e\u3059<\/li>\n\n\n\n<li>SQL \u7d50\u679c\u306e\u30ab\u30e9\u30e0\u304c\u5c11\u306a\u3044\u5834\u5408\u306f\u3001\u5bfe\u5fdc\u3057\u306a\u3044\u30c6\u30fc\u30d6\u30eb\u9805\u76ee\u306b\u7a7a\u304c\u8a2d\u5b9a\u3055\u308c\u307e\u3059<\/li>\n\n\n\n<li>SQL \u7d50\u679c\u306e\u30ab\u30e9\u30e0\u304c\u591a\u3044\u5834\u5408\u306f\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\uff3b\u5404\u30ab\u30e9\u30e0\u306e\u5024\u3092\u6539\u884c\u533a\u5207\u308a\u3067\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3059\u308b\uff3d<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u5404\u30ab\u30e9\u30e0\u306e\u5024\u3054\u3068\u306b\u3001\u500b\u5225\u306e\u8907\u6570\u884c\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3067\u304d\u307e\u3059<\/li>\n\n\n\n<li>\u9078\u629e\u80a2\u30de\u30b9\u30bf\u66f4\u65b0\u306a\u3069\u3078\u306e\u5fdc\u7528\u304c\u3067\u304d\u307e\u3059<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\uff3b\u5404\u30bb\u30eb\u306e\u5024\u3092\u5225\u3005\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3059\u308b\uff3d<\/strong>\n<ul class=\"wp-block-list\">\n<li>\u5404\u30bb\u30eb\u306e\u5024\u3054\u3068\u306b\u3001\u4fdd\u5b58\u5148\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u500b\u5225\u306b\u8a2d\u5b9a\u3067\u304d\u307e\u3059<\/li>\n\n\n\n<li>\u4fdd\u5b58\u5148\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u4e26\u3073\u9806\u3092\u5909\u66f4\u3067\u304d\u307e\u3059<\/li>\n\n\n\n<li>\u6587\u5b57\u578b\uff08\u8907\u6570\u884c\uff09\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u5404\u884c\u306e\u6570\u5b57\u3092\u5404\u6570\u5024\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u76f4\u63a5\u4fdd\u5b58\u3067\u304d\u307e\u3059<\/li>\n\n\n\n<li>\u8907\u6570\u306e\u96c6\u8a08\u7d50\u679c\u300c\u6700\u5927\u300d\u300c\u5e73\u5747\u300d\u300c\u5408\u8a08\u300d\u306a\u3069\u306e\u4e00\u62ec\u4fdd\u5b58\u3082\u3067\u304d\u307e\u3059\u3001\u3053\u308c\u3092\u5b9f\u73fe\u3059\u308b\u305f\u3081\u306e\u30af\u30a8\u30ea\u6307\u5b9a\u65b9\u6cd5\u306f\u300c\u30af\u30a8\u30ea\u306e\u4f8b\u300d\u3092\u3054\u89a7\u304f\u3060\u3055\u3044<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-medium has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"504\" height=\"315\" data-attachment-id=\"180126\" data-permalink=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-csv-update\/attachment\/service-task-csv-update-save-col-ja\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-col-ja.png?fit=1200%2C750&amp;ssl=1\" data-orig-size=\"1200,750\" 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=\"service-task-csv-update-save-col-ja\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-col-ja.png?fit=1008%2C630&amp;ssl=1\" data-id=\"180126\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-col-ja.png?resize=504%2C315&#038;ssl=1\" alt=\"\" class=\"has-border-color has-vivid-green-cyan-border-color wp-image-180126\" style=\"border-width:3px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-col-ja.png?resize=504%2C315&amp;ssl=1 504w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-col-ja.png?resize=1008%2C630&amp;ssl=1 1008w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-col-ja.png?resize=768%2C480&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-col-ja.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-medium has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"504\" height=\"315\" data-attachment-id=\"180128\" data-permalink=\"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-csv-update\/attachment\/service-task-csv-update-save-cell-ja\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-cell-ja.png?fit=1200%2C750&amp;ssl=1\" data-orig-size=\"1200,750\" 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=\"service-task-csv-update-save-cell-ja\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-cell-ja.png?fit=1008%2C630&amp;ssl=1\" data-id=\"180128\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-cell-ja.png?resize=504%2C315&#038;ssl=1\" alt=\"\" class=\"has-border-color has-vivid-green-cyan-border-color wp-image-180128\" style=\"border-width:3px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-cell-ja.png?resize=504%2C315&amp;ssl=1 504w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-cell-ja.png?resize=1008%2C630&amp;ssl=1 1008w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-cell-ja.png?resize=768%2C480&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/service-task-csv-update-save-cell-ja.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" \/><\/figure>\n<\/figure>\n\n\n\n<h2 id=\"\u30af\u30a8\u30ea\u306e\u4f8b\" class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">\u30af\u30a8\u30ea\u306e\u4f8b<\/span><\/h2>\n\n\n\n<h4 id=\"\u5c04\u5f71\" class=\"wp-block-heading\">\u5c04\u5f71<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism off-numbers lang-sql\" data-lang=\"SQL\"><code>select &quot;\u5546\u54c1ID&quot;, &quot;\u5546\u54c1\u540d&quot;, &quot;\u4fa1\u683c&quot;\nfrom &quot;\u5546\u54c1&quot;<\/code><\/pre><\/div>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism off-numbers lang-sql\" data-lang=\"SQL\"><code>select * except(&quot;\u5546\u54c1ID&quot;)\nfrom &quot;q_products&quot;<\/code><\/pre><\/div>\n\n\n\n<h4 id=\"\u9078\u629e\" class=\"wp-block-heading\">\u9078\u629e<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism off-numbers lang-sql\" data-lang=\"SQL\"><code>select *\nfrom &quot;\u5546\u54c1&quot;\nwhere &quot;\u5546\u54c1ID&quot; like &#39;p123-%&#39;<\/code><\/pre><\/div>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism off-numbers lang-sql\" data-lang=\"SQL\"><code>select *\nfrom &quot;\u5546\u54c1&quot;\nwhere cast(&quot;\u4fa1\u683c&quot; as integer) &gt; 1000<\/code><\/pre><\/div>\n\n\n\n<h4 id=\"\u96c6\u8a08\u95a2\u6570\" class=\"wp-block-heading\">\u96c6\u8a08\u95a2\u6570<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism off-numbers lang-sql\" data-lang=\"SQL\"><code>select\n  max(cast(&quot;\u4fa1\u683c&quot; as integer)) as &quot;\u6700\u5927\u4fa1\u683c&quot;,\n  min(cast(&quot;\u4fa1\u683c&quot; as integer)) as &quot;\u6700\u5c0f\u4fa1\u683c&quot;,\n  avg(cast(&quot;\u4fa1\u683c&quot; as integer)) as &quot;\u5e73\u5747\u4fa1\u683c&quot;,\n  sum(cast(&quot;\u4fa1\u683c&quot; as integer)) as &quot;\u5408\u8a08\u4fa1\u683c&quot;\nfrom &quot;\u5546\u54c1&quot;;<\/code><\/pre><\/div>\n\n\n\n<h4 id=\"\u7d50\u5408\" class=\"wp-block-heading\">\u7d50\u5408<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism off-numbers lang-sql\" data-lang=\"SQL\"><code>select p.*, s.* except(s.&quot;\u5546\u54c1ID&quot;)\nfrom &quot;\u5546\u54c1&quot; as p join &quot;\u58f2\u4e0a&quot; as s on p.&quot;\u5546\u54c1ID&quot; = s.&quot;\u5546\u54c1ID&quot;<\/code><\/pre><\/div>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 id=\"see-also\" class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--30)\"><span>See also<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.questetra.com\/ja\/developer-blog\/csv-update-sql\/\" data-type=\"link\" data-id=\"https:\/\/support.questetra.com\/ja\/developer-blog\/csv-update-sql\/\" target=\"_blank\" rel=\"noreferrer noopener\">CSV\u30c7\u30fc\u30bf\u52a0\u5de5\u3001\u624b\u4f5c\u696d\u304b\u3089\u81ea\u52d5\u5316\u3078\uff01<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6587\u5b57\u578b\uff08\u8907\u6570\u884c\uff09\u306b\u5165\u529b\u3055\u308c\u305f CSV \/ TSV \u30c7\u30fc\u30bf\u3092 RDB \u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u6271\u3044\u3001\u30af\u30a8\u30ea\uff08SQL\uff09\u306b\u3088\u308a\u30c7\u30fc\u30bf\u3092\u64cd\u4f5c\u3057\u307e\u3059\u3002\u30af\u30a8\u30ea\u5b9f\u884c\u7d50\u679c\u306f\u6307\u5b9a\u3057\u305f\u6587\u5b57\u578b\uff08\u8907\u6570\u884c\uff09\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u4fdd\u5b58\u3055\u308c\u307e\u3059\u30022\u3064\u306e\u30c7\u30fc\u30bf\u3092\u7d50\u5408\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"author":3,"featured_media":168914,"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_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":[550],"tags":[451],"faq_section":[],"class_list":["post-168912","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bpmn-icons","tag-tsv-csv"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/ja\/author\/nishiquestetra\/"},"uagb_comment_info":7,"uagb_excerpt":"\u6587\u5b57\u578b\uff08\u8907\u6570\u884c\uff09\u306b\u5165\u529b\u3055\u308c\u305f CSV \/ TSV \u30c7\u30fc\u30bf\u3092 RDB \u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u6271\u3044\u3001\u30af\u30a8\u30ea\uff08SQL\uff09\u306b\u3088\u308a&hellip;","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-HWo","jetpack-related-posts":[{"id":82450,"url":"https:\/\/support.questetra.com\/ja\/bpmn-icons\/converter-excelcsv-to-table\/","url_meta":{"origin":168912,"position":0},"title":"\u30b3\u30f3\u30d0\u30fc\u30bf (TSV \u30d5\u30a1\u30a4\u30eb to \u30c6\u30fc\u30d6\u30eb\u578b\u30c7\u30fc\u30bf)","author":"Shiho Tatsumi","date":"2024-08-01","format":false,"excerpt":"\u3053\u306e\u5de5\u7a0b\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u5024\u3092\u3001\u30d5\u30a1\u30a4\u30eb\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b Excel \u5bfe\u5fdc CS\u2026","rel":"","context":"BPMN\u30a2\u30a4\u30b3\u30f3","block_context":{"text":"BPMN\u30a2\u30a4\u30b3\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82382,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-string-sort-by-text\/","url_meta":{"origin":168912,"position":1},"title":"TSV\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30bd\u30fc\u30c8","author":"IMAMURA, Genichi","date":"2019-12-03","format":false,"excerpt":"\u6307\u5b9a\u30ab\u30e9\u30e0\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u9806\u3067TSV\u30c6\u30ad\u30b9\u30c8\u3092\u884c\u30bd\u30fc\u30c8\u3057\u307e\u3059\u3002\u5404\u884c\u306e\u30ab\u30e9\u30e0\u5024\u304c\u300cJan\u300d\u300cFeb\u300d\u300cMa\u2026","rel":"","context":"Add-ons","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV\u6587\u5b57\u5217, \u30c6\u30ad\u30b9\u30c8\u30bd\u30fc\u30c8","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-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\/12\/TSV-String-Sort-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":84626,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-kick-httpstartevent-by-tsv\/","url_meta":{"origin":168912,"position":2},"title":"Questetra BPMS: \u6848\u4ef6, TSV\u30c7\u30fc\u30bf\u306b\u3088\u308bHTTP\u958b\u59cb\u30a4\u30d9\u30f3\u30c8\u306e\u30ad\u30c3\u30af","author":"IMAMURA, Genichi","date":"2021-02-17","format":false,"excerpt":"TSV\u306e\u6307\u5b9a\u884c\u30c7\u30fc\u30bf\u3092\u7528\u3044\u3066HTTP\u958b\u59cb\u30a4\u30d9\u30f3\u30c8\u3092\u30ad\u30c3\u30af\u3057\u307e\u3059\u3002\u8907\u6570\u884cTSV\u30c7\u30fc\u30bf\u306b\u3088\u308b\u4e00\u62ec\u8d77\u52d5\u3092\u60f3\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS# \u6848\u4ef6: TSV\u30c7\u30fc\u30bf\u306b\u3088\u308bHTTP\u958b\u59cb\u30a4\u30d9\u30f3\u30c8\u306e\u30ad\u30c3\u30af","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Questetra-BPMS-Process-Kick-HttpStartEvent-by-TSV-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\/2020\/02\/Questetra-BPMS-Process-Kick-HttpStartEvent-by-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Questetra-BPMS-Process-Kick-HttpStartEvent-by-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Questetra-BPMS-Process-Kick-HttpStartEvent-by-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Questetra-BPMS-Process-Kick-HttpStartEvent-by-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":178794,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/csv-update-utilize\/","url_meta":{"origin":168912,"position":3},"title":"\u30d8\u30c3\u30c0\u306a\u3057\u30c7\u30fc\u30bf\u3082OK\uff01\uff3bCSV \u30c7\u30fc\u30bf\u66f4\u65b0\uff3d\u306e\u5165\u529b\uff0f\u51fa\u529b\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u5b8c\u5168\u7406\u89e3","author":"komatsuquestetra","date":"2025-11-13","format":false,"excerpt":"\uff3bCSV \u30c7\u30fc\u30bf\u66f4\u65b0\uff3d\u306e\u4f7f\u3044\u65b9\u3067\u3001\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u5229\u7528\u3057\u306a\u304c\u3089\u5fdc\u7528\u3059\u308b\u30a2\u30a4\u30c7\u30a2\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002","rel":"","context":"Questetra Developers Blog","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/ja\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/11\/eyecatch-csv-update-utilize-ja.png?fit=1200%2C670&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/11\/eyecatch-csv-update-utilize-ja.png?fit=1200%2C670&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/11\/eyecatch-csv-update-utilize-ja.png?fit=1200%2C670&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/11\/eyecatch-csv-update-utilize-ja.png?fit=1200%2C670&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/11\/eyecatch-csv-update-utilize-ja.png?fit=1200%2C670&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":78058,"url":"https:\/\/support.questetra.com\/ja\/addons\/multiline-string-delete-header-lines\/","url_meta":{"origin":168912,"position":4},"title":"\u8907\u6570\u884c\u6587\u5b57\u5217; \u30d8\u30c3\u30c0\u884c\u306e\u524a\u9664","author":"IMAMURA, Genichi","date":"2019-07-29","format":false,"excerpt":"\u8907\u6570\u884c\u6587\u5b57\u5217\u306e\u5148\u982d\u884c\u3092\u524a\u9664\u3057\u307e\u3059\u3002CSV\u30c6\u30ad\u30b9\u30c8\u3084TSV\u30c6\u30ad\u30b9\u30c8\u306e\u30d8\u30c3\u30c0\u30fc\u524a\u9664\u306a\u3069\u3067\u5229\u7528\u3067\u304d\u307e\u3059\u3002\u306a\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","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\/07\/Multiline-String-Delete-Head-Lines-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\/07\/Multiline-String-Delete-Head-Lines-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Multiline-String-Delete-Head-Lines-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Multiline-String-Delete-Head-Lines-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Multiline-String-Delete-Head-Lines-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82453,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/converter-excelcsv-to-table\/","url_meta":{"origin":168912,"position":5},"title":"Converter (TSV File to Table type data)","author":"Shiho Tatsumi","date":"2024-08-01","format":false,"excerpt":"This item overwrites the value of a Table type dat\u2026","rel":"","context":"BPMN Icons","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.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\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/168912","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/comments?post=168912"}],"version-history":[{"count":127,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/168912\/revisions"}],"predecessor-version":[{"id":186615,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/168912\/revisions\/186615"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/media\/168914"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/media?parent=168912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/categories?post=168912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/tags?post=168912"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/faq_section?post=168912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}