{"id":180434,"date":"2026-03-05T16:01:23","date_gmt":"2026-03-05T07:01:23","guid":{"rendered":"https:\/\/support.questetra.com\/?p=180434"},"modified":"2026-08-21T11:53:12","modified_gmt":"2026-08-21T02:53:12","slug":"csv-update-csv","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/","title":{"rendered":"Automate Data Processing with [Update CSV Data]"},"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=\"113160\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/how-to-use-timer-start-event\/attachment\/advanced-banner-new-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,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-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en-1024x58.png?resize=1024%2C58&#038;ssl=1\" alt=\"\" class=\"wp-image-113160\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?resize=768%2C44&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/advanced-banner-new-en.png?w=1200&amp;ssl=1 1200w\" 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<p class=\"wp-block-paragraph\">Data transfer between business systems often relies on the CSV (Comma-Separated Values) format.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Questetra&#8217;s Auto-Processing Task, [<a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/\" data-type=\"link\" data-id=\"https:\/\/support.questetra.com\/bpmn-icons\/service-task-csv-update\/\" target=\"_blank\" rel=\"noreferrer noopener\">Update CSV Data<\/a>] allows you to automate the processing and transformation of CSV data directly within your workflow. This includes tasks like extracting specific rows or columns.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[Update CSV Data] related articles:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Automating Data Processing with [Update CSV Data]<\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-various\/\">Supporting Various Data Input\/Output with [Update CSV Data]<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-aggregate\/\">Automating Data Aggregation with [Update CSV Data]<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-choice-master\/\" data-type=\"link\" data-id=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-choice-master\/\">Building a Choice Master with [Update CSV Data]<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">1. About the [Update CSV Data] Step<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1-1. Step Overview<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">[<a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/\">Update CSV Data<\/a>] is a built-in, automated processing task available on the Advanced and Professional workflow platforms.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Its key feature is that it treats CSV data saved as a multi-line string as a relational database table. This allows users to manipulate the data using SQL queries.<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"560\" height=\"315\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=560%2C315&#038;ssl=1\" alt=\"\" class=\"wp-image-168914\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?resize=768%2C432&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">1-2. Benefits of Automating CSV Processing<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Using Update CSV Data offers several advantages:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Reduces the need for manual CSV editing<\/li>\n\n\n\n<li>Ensures consistent data processing by applying the same rules every time<\/li>\n\n\n\n<li>Integrates CSV processing seamlessly into your workflow<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This feature is particularly useful for tasks involving repetitive, standardized CSV processing.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. Basic Configuration<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">2-1. Input Data<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>C1: Specifying Data Items to Load<\/strong>\n<ul class=\"wp-block-list\">\n<li>Define the String-type (multi-line) data item where your CSV data is stored<\/li>\n\n\n\n<li>You can also specify the table name that will be used in your SQL query (e.g. &#8220;List&#8221;)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>C2: Specifying Additional Data<\/strong>\n<ul class=\"wp-block-list\">\n<li>Use this option when working with a second set of CSV data<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2-2. Query<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Specifying Table and Column Names:<br><\/strong> Table and column names must be enclosed in double quotes (e.g. `SELECT * FROM &#8220;List&#8221;`)<\/li>\n\n\n\n<li><strong>Be Aware of Restricted Words:<br><\/strong>Certain terms are prohibited for security reasons<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2-3. Save Settings<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>To retain both the original data and the processing results, specify a different data item for saving the output<\/strong><\/li>\n\n\n\n<li><strong>Selecting the same data item as C1 will overwrite the original data<\/strong><strong><br><\/strong>This is convenient if you no longer need the original CSV data<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped has-border-color has-ast-global-color-3-border-color wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\" style=\"border-width:3px\">\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"630\" data-attachment-id=\"180357\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/attachment\/csv-update-input-data-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en.jpg?fit=883%2C834&amp;ssl=1\" data-orig-size=\"883,834\" 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-en\" 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-en.jpg?fit=667%2C630&amp;ssl=1\" data-id=\"180357\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en-667x630.jpg?resize=667%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-180357\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en.jpg?resize=667%2C630&amp;ssl=1 667w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en.jpg?resize=334%2C315&amp;ssl=1 334w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en.jpg?resize=768%2C725&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-input-data-en.jpg?w=883&amp;ssl=1 883w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"756\" height=\"630\" data-attachment-id=\"180372\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/attachment\/csv-update-query-en2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?fit=894%2C745&amp;ssl=1\" data-orig-size=\"894,745\" 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-en2\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?fit=756%2C630&amp;ssl=1\" data-id=\"180372\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2-756x630.jpg?resize=756%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-180372\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?resize=756%2C630&amp;ssl=1 756w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?resize=378%2C315&amp;ssl=1 378w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?resize=768%2C640&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-query-en2.jpg?w=894&amp;ssl=1 894w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"668\" height=\"630\" data-attachment-id=\"180374\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/attachment\/csv-update-save-settings-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en.jpg?fit=883%2C833&amp;ssl=1\" data-orig-size=\"883,833\" 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-en\" 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-en.jpg?fit=668%2C630&amp;ssl=1\" data-id=\"180374\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en-668x630.jpg?resize=668%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-180374\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en.jpg?resize=668%2C630&amp;ssl=1 668w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en.jpg?resize=334%2C315&amp;ssl=1 334w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en.jpg?resize=768%2C725&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2025\/01\/csv-update-save-settings-en.jpg?w=883&amp;ssl=1 883w\" sizes=\"auto, (max-width: 668px) 100vw, 668px\" \/><\/figure>\n<\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">3. Processing CSV with Queries<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The examples in this section illustrate typical processing flows.<br>\nThese examples use the following sample CSV data:<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>id,name,status\n1,Yamada,Active\n2,Sato,Inactive\n3,Suzuki,Active<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">3-1. Filtering Rows<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Generates a CSV file containing only rows that match a condition.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Query example<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT *\nFROM &quot;List&quot;\u00a0\nWHERE &quot;status&quot; = &#39;Active&#39;<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"597\" height=\"123\" data-attachment-id=\"180438\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/attachment\/csv-update-csv-3-1-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-1-en.jpg?fit=597%2C123&amp;ssl=1\" data-orig-size=\"597,123\" 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-csv-3-1-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-1-en.jpg?fit=597%2C123&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-1-en.jpg?resize=597%2C123&#038;ssl=1\" alt=\"\" class=\"has-border-color has-ast-global-color-3-border-color wp-image-180438\" style=\"border-width:3px\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3-2. Selecting Columns<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Generates a CSV containing only specified columns.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Query example<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT &quot;id&quot;,&quot;name&quot;\u00a0\nFROM &quot;List&quot;<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"597\" height=\"124\" data-attachment-id=\"180440\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/attachment\/csv-update-csv-3-2-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-2-en.jpg?fit=597%2C124&amp;ssl=1\" data-orig-size=\"597,124\" 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-csv-3-2-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-2-en.jpg?fit=597%2C124&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-2-en.jpg?resize=597%2C124&#038;ssl=1\" alt=\"\" class=\"has-border-color has-ast-global-color-3-border-color wp-image-180440\" style=\"border-width:3px\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3-3. Reordering Columns<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Control the column order in the output CSV.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Query example<\/h4>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT &quot;name&quot;,&quot;id&quot;,&quot;status&quot;\u00a0\nFROM &quot;List&quot;<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"620\" height=\"124\" data-attachment-id=\"180442\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/attachment\/csv-update-csv-3-3-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-3-en.jpg?fit=620%2C124&amp;ssl=1\" data-orig-size=\"620,124\" 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-csv-3-3-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-3-en.jpg?fit=620%2C124&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-3-en.jpg?resize=620%2C124&#038;ssl=1\" alt=\"\" class=\"has-border-color has-ast-global-color-3-border-color wp-image-180442\" style=\"border-width:3px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-3-en.jpg?w=620&amp;ssl=1 620w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/csv-update-csv-3-3-en.jpg?resize=600%2C120&amp;ssl=1 600w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">4. Summary<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Questetra&#8217;s [Update CSV Data] automates CSV data processing by:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Loading CSV data<\/li>\n\n\n\n<li>Treating the data as a database table<\/li>\n\n\n\n<li>Processing the data using SQL queries<\/li>\n\n\n\n<li>Outputting the results as CSV<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">By automating these steps, you can significantly reduce manual CSV editing, seamlessly integrate CSV processing into your workflows, and achieve more efficient and error-free operations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By placing [Update CSV Data] in the workflow diagram, the CSV data stored in the specified string-type data field will be processed automatically.<\/p>\n","protected":false},"author":6,"featured_media":180220,"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":[296],"tags":[],"faq_section":[],"class_list":["post-180434","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer-blog"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"komatsuquestetra","author_link":"https:\/\/support.questetra.com\/en\/author\/komatsuquestetra\/"},"uagb_comment_info":2,"uagb_excerpt":"By placing [Update CSV Data] in the workflow diagram, the CSV data stored in the specified string-type data field will be processed automatically.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-KWe","jetpack-related-posts":[{"id":181393,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-various\/","url_meta":{"origin":180434,"position":0},"title":"Supporting Various Data Input\/Output with [Update CSV Data]","author":"komatsuquestetra","date":"2026-04-02","format":false,"excerpt":"By using the [Update CSV Data] Step appropriately, you can also process data that is not in CSV format.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":193634,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-choice-master\/","url_meta":{"origin":180434,"position":1},"title":"Building a Choice Master with [Update CSV Data]","author":"komatsuquestetra","date":"2026-04-14","format":false,"excerpt":"Creating or updating the Choice master by combining [Update CSV Data] and [Update Choices]","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":179002,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-utilize\/","url_meta":{"origin":180434,"position":2},"title":"Headerless Data Is OK! Fully Understand the Input\/Output Options of [Update CSV Data]","author":"komatsuquestetra","date":"2025-11-19","format":false,"excerpt":"Here are some ideas for applying the [Update CSV Data] feature using its options.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/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":181437,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-aggregate\/","url_meta":{"origin":180434,"position":3},"title":"Automating Data Aggregation with [Update CSV Data]","author":"komatsuquestetra","date":"2026-03-31","format":false,"excerpt":"We will use the aggregation function in [Update CSV Data], and also show you how to save the aggregated results directly to a Numeric-type data item.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69682,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/converter-tabletoexcelcsv\/","url_meta":{"origin":180434,"position":4},"title":"Converter (Table type data to Excel-CSV File)","author":"Shiho Tatsumi","date":"2024-07-05","format":false,"excerpt":"This item stores the values in a Table type data item into a File type data item as an Excel compatible CSV. The file is added and does not affect existing files.","rel":"","context":"In &quot;BPMN Icons&quot;","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":[]},{"id":117198,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-multiline-string-to-singleline-csv-string-2021\/","url_meta":{"origin":180434,"position":5},"title":"Converter: Multiline-String to Singleline-CSV-String","author":"IMAMURA, Genichi","date":"2021-11-22","format":false,"excerpt":"Converts a multiline string to a CSV string. Converts each row of a multiline string as the value of each cell in the CSV. If commas are included they will be deleted in advance. Lines with only line feed code are recognized as empty data.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter, Multiline-String to Singleline-CSV-String","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-nocode-en.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\/2026\/01\/eyecatch-csv-update2.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/180434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=180434"}],"version-history":[{"count":12,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/180434\/revisions"}],"predecessor-version":[{"id":193688,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/180434\/revisions\/193688"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/180220"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=180434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=180434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=180434"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=180434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}