{"id":181437,"date":"2026-03-31T17:36:12","date_gmt":"2026-03-31T08:36:12","guid":{"rendered":"https:\/\/support.questetra.com\/?p=181437"},"modified":"2026-08-21T12:15:04","modified_gmt":"2026-08-21T03:15:04","slug":"csv-update-aggregate","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-aggregate\/","title":{"rendered":"Automating Data Aggregation with [Update CSV Data]"},"content":{"rendered":"\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<p class=\"wp-block-paragraph\">This article explains how to efficiently use SQL aggregate functions to analyze and update numerical data within your CSV files using the [<a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/\" target=\"_blank\" rel=\"noreferrer noopener\">Update CSV Data<\/a>] Step. We&#8217;ll cover the basics of aggregate functions and provide configuration examples that show you how to calculate multiple aggregate results in a single query, saving each result to individual Numeric-type Data Items.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Plus, the <a href=\"#appendix\">Appendix<\/a> offers tips on using generative AI to create queries and troubleshoot common issues.<\/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><a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/\">Automate Data Processing with [Update CSV Data]<\/a><\/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>Automating Data Aggregation with [Update CSV Data]<\/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. Understanding Aggregate Functions<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQL aggregate functions let you calculate totals, averages, minimums, maximums, and more from your CSV data. In the [Update CSV Data] Step, numerical values from the CSV are initially treated as text. To perform calculations, you&#8217;ll need to convert them to a numeric type (like integer) within your SQL query using the `CAST` function.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SUM<\/strong>: Calculates the total<\/li>\n\n\n\n<li><strong>AVG<\/strong>: Calculates the average<\/li>\n\n\n\n<li><strong>MAX \/ MIN<\/strong>: Determines the maximum and minimum values<\/li>\n<\/ul>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT\n  SUM(CAST(&quot;Sales&quot; as integer))\nFROM &quot;SalesTable&quot;<\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">2. Aggregating Your Data<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">2-1. Calculating Daily Sales Totals<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This example shows how to aggregate daily sales amounts from a &#8220;SalesTable&#8221;.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Configuration Example<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Output Options<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>For [C4: How to save query results], select &#8220;Save the entire table as a single data item in CSV\/TSV format&#8221;<\/li>\n\n\n\n<li>For [C4b: Data Format When Saving], specify &#8220;Header Included  (1 row: column names, data starts from row 2)&#8221;.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Query Example<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">From the \u201cSales Table\u201d, that is set in [C1b: Table name when accessed by query], converts the values in the \u201cSales\u201d column from the data into numbers, sums them for each date, and sorts them by date.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT\n  &quot;Date&quot;,\n  SUM(CAST(&quot;Sales&quot; as integer)) AS &quot;Total Sales&quot;\nFROM &quot;Sales Table&quot;\nGROUP BY &quot;Date&quot;\nORDER BY &quot;Date&quot;<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"428\" data-attachment-id=\"181442\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-aggregate\/attachment\/csv-update-aggregate-sum-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-sum-en.png?fit=960%2C428&amp;ssl=1\" data-orig-size=\"960,428\" 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-aggregate-sum-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-sum-en.png?fit=960%2C428&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-sum-en.png?resize=960%2C428&#038;ssl=1\" alt=\"\" class=\"has-border-color has-ast-global-color-8-border-color wp-image-181442\" style=\"border-width:3px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-sum-en.png?w=960&amp;ssl=1 960w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-sum-en.png?resize=600%2C268&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-sum-en.png?resize=768%2C342&amp;ssl=1 768w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><figcaption class=\"wp-element-caption\">Daily Sales Total<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">2-2. Saving the Aggregated Results to a Numeric-type<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">By selecting the [Save each cell value to a separate data item] option, you can save multiple calculated aggregate values \u200b\u200bto <strong>multiple Numeric-type Data Items simultaneously<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For instance, with a single query on your &#8220;Sales Table&#8221; data, you can calculate the maximum, average, and total sales, and then save each of these values to separate data items.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Configuration Example<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Output Options<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>For [<strong>C4: How to save query results<\/strong>] , select &#8220;<strong>Save each cell value to a separate data item<\/strong>&#8220;<\/li>\n\n\n\n<li>For [<strong>C4a: Data item that will save query results<\/strong>], specify which data item should be used to store the value from each cell in the first row of the query result<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Query Result Cell<\/strong><\/td><td><strong>Data Item for Saving<\/strong><\/td><\/tr><tr><td>First Cell (Highest Value: MAX)<\/td><td>Numeric: Highest Sales<\/td><\/tr><tr><td>Second Cell (Average Value: AVG)<\/td><td>Numeric: Average Sales<\/td><\/tr><tr><td>Third Cell (Total Value: SUM)<\/td><td>Numeric: Total Sales<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Query Example<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">From the \u201cSales Table\u201d, that is set in [C1b: Table name when accessed by query], converts values in the \u201cSales\u201d column into numbers and calculates them using functions. Each function is positioned so that the first cell outputs the maximum value, the second the average value, and the third the total value.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>SELECT\n\u00a0\u00a0\u00a0MAX(CAST(&quot;Sales&quot; as integer)),\n\u00a0\u00a0\u00a0AVG(CAST(&quot;Sales&quot; as integer)),\n\u00a0\u00a0\u00a0SUM(CAST(&quot;Sales&quot; as integer))\u00a0\nFROM &quot;Sales Table&quot;<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full has-custom-border\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"914\" height=\"540\" data-attachment-id=\"181444\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-aggregate\/attachment\/csv-update-aggregate-separate-en-1\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-separate-en-1.png?fit=914%2C540&amp;ssl=1\" data-orig-size=\"914,540\" 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-aggregate-separate-en-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-separate-en-1.png?fit=914%2C540&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-separate-en-1.png?resize=914%2C540&#038;ssl=1\" alt=\"\" class=\"has-border-color has-ast-global-color-8-border-color wp-image-181444\" style=\"border-width:3px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-separate-en-1.png?w=914&amp;ssl=1 914w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-separate-en-1.png?resize=533%2C315&amp;ssl=1 533w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/csv-update-aggregate-separate-en-1.png?resize=768%2C454&amp;ssl=1 768w\" sizes=\"auto, (max-width: 914px) 100vw, 914px\" \/><figcaption class=\"wp-element-caption\">Saving to Three Separate Numeric-type Data Items<\/figcaption><\/figure>\n\n\n\n<p class=\"is-style-info wp-block-paragraph\">The [CSV Data Update] function allows you to specify [Text Type (Single Line)] data items as the input target using input options. This allows even a single string to be treated as a single-row, single-column CSV data entry.<br><br>Using this mechanism, you can read a number stored as STRING in [Text Type (Single Line)] and save them to [Numeric-Type] data items. In other words, you can <strong>convert numbers stored as STRING into NUMERIC data<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. Summary<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Data aggregation, which used to require scripting or complex configurations, can now be done simply with SQL. By saving the aggregation results to Numeric data items, you can immediately use them in subsequent Steps for conditional branching (e.g. &#8220;If the total amount is $\u3007\u3007 or more, proceed to the Approval Flow&#8221;) or report generation.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" style=\"margin-top:var(--wp--preset--spacing--80);margin-bottom:var(--wp--preset--spacing--80)\"\/>\n\n\n\n<h2 id=\"appendix\" class=\"wp-block-heading\">Appendix: Creating Queries with Generative AI and Troubleshooting<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. Creating Queries with ChatGPT<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You can use generative AI tools like ChatGPT to quickly create SQL queries by simply describing the task you want to accomplish. For example, you could ask it: &#8220;Join product master and sales data by product ID and extract only products with an amount of $100 or more.&#8221;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Even without SQL knowledge, you can express your desired processing steps<\/li>\n\n\n\n<li>Including instructions like &#8220;a query suitable for an H2 Database&#8221; will help the AI provide a more accurate response\n<ul class=\"wp-block-list\">\n<li>H2 Database is the RDB used internally<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Remember to adjust table and column names to match your specific workflow application before using the generated SQL directly.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Here&#8217;s an example where ChatGPT (o1) generated SQL. The prompt was adjusted slightly based on the above instructions to improve the output. In this case, because &#8220;Product ID&#8221; was a string and not a number, type conversion (`CAST`) wasn&#8217;t needed. Simply removing that part allowed the query to work correctly and produce the expected result.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"535\" height=\"630\" data-attachment-id=\"181482\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-aggregate\/attachment\/sql-query-by-chatgpt-en1\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/sql-query-by-chatgpt-en1.png?fit=768%2C904&amp;ssl=1\" data-orig-size=\"768,904\" 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=\"sql-query-by-chatgpt-en1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/sql-query-by-chatgpt-en1.png?fit=535%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/sql-query-by-chatgpt-en1-535x630.png?resize=535%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-181482\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/sql-query-by-chatgpt-en1.png?resize=535%2C630&amp;ssl=1 535w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/sql-query-by-chatgpt-en1.png?resize=268%2C315&amp;ssl=1 268w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/03\/sql-query-by-chatgpt-en1.png?w=768&amp;ssl=1 768w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><figcaption class=\"wp-element-caption\">Example Prompt to ChatGPT and Generated SQL Query<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">2. Common Errors and Solutions<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If an operation fails, check the error details in the [Error Notification Email] or the [Case Log] to troubleshoot the problem. You can access the [Case Log] by activating &#8220;Admin Mode&#8221; on the Case details screen. (You need [Control Permission] on the target application to enable &#8220;Admin Mode&#8221;.)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Column Name Issues\n<ul class=\"wp-block-list\">\n<li>Errors can occur if column names contain spaces, exceed 64 characters, or are duplicated<\/li>\n\n\n\n<li>Double-check the header row (the first row) for typos<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Query Syntax Errors\n<ul class=\"wp-block-list\">\n<li>Common errors include forgetting double quotes or using the wrong order for `WHERE` and `FROM` clauses<\/li>\n\n\n\n<li>Always double-check the syntax, even when using AI-generated SQL<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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.<\/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":"","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-181437","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":1,"uagb_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.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-Lcp","jetpack-related-posts":[{"id":179002,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-utilize\/","url_meta":{"origin":181437,"position":0},"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":169910,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-csv-update\/","url_meta":{"origin":181437,"position":1},"title":"Update CSV Data","author":"Hirotaka NISHI","date":"2025-01-15","format":false,"excerpt":"CSV\/TSV data entered as String-type (multiple lines) is treated as an RDB table, and the data is manipulated by queries (SQL). The results of the query are saved in the specified String-type (multiple lines) Data Item. Two data can also be combined.","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\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/12\/bpmn-icon-service-task-csv-update.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":181393,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-various\/","url_meta":{"origin":181437,"position":2},"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":180434,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/csv-update-csv\/","url_meta":{"origin":181437,"position":3},"title":"Automate Data Processing with [Update CSV Data]","author":"komatsuquestetra","date":"2026-03-05","format":false,"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.","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":181437,"position":4},"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":112902,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-create-summary-table-of-count-2021\/","url_meta":{"origin":181437,"position":5},"title":"TSV String, Create Summary Table of Count","author":"IMAMURA, Genichi","date":"2021-09-13","format":false,"excerpt":"Aggregates the count of data by aggregation-keys. Count and Percentage are tabulated as a summary table TSV. Eg, Survey Results TSV is automatically generated from Survey Records TSV. Frequency distribution.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Create Summary Table of Count","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-create-summary-table-of-count-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\/09\/tsv-string-create-summary-table-of-count-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-create-summary-table-of-count-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\/09\/tsv-string-create-summary-table-of-count-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/tsv-string-create-summary-table-of-count-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\/181437","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=181437"}],"version-history":[{"count":16,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/181437\/revisions"}],"predecessor-version":[{"id":193699,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/181437\/revisions\/193699"}],"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=181437"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=181437"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=181437"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=181437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}