{"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-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-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-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-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_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_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":82259,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/service-task-calculation-decimal\/","url_meta":{"origin":181437,"position":0},"title":"Let&#8217;s Calculate the Total Amount Automatically","author":"Hirotaka NISHI","date":"2021-10-07","format":false,"excerpt":"Let's implement a total amount calculation and a variable discount setup with conditions. A Table-type Data Item and a Update Data are vital.","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\/2020\/04\/eye-catch-update_data-caliculation-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\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/04\/eye-catch-update_data-caliculation-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":68661,"url":"https:\/\/support.questetra.com\/en\/versions\/version-1130\/","url_meta":{"origin":181437,"position":1},"title":"v11.3 2017-03-13: Renewing Workflow screen for Smartphones","author":"Hirotaka NISHI","date":"2017-02-28","format":false,"excerpt":"Release Overview Date Release SaaS Edition : Mon. Mar. 13th, 2017 Download Edition : None Changes to be Noted Parameter of \"option\" is obsolete in API for \"Querying for Task records operated by the User\" Change the naming of \"Process Model\" to \"Application\". We will also change related terms. Check\u2026","rel":"","context":"In &quot;Version Info&quot;","block_context":{"text":"Version Info","link":"https:\/\/support.questetra.com\/en\/category\/versions\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/02\/version-1130-fi-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\/2017\/02\/version-1130-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/02\/version-1130-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/02\/version-1130-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/02\/version-1130-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":77067,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/download-process-data\/","url_meta":{"origin":181437,"position":2},"title":"Downloading Case and Task Lists Using Workflow API (reportId)","author":"Hirotaka NISHI","date":"2022-01-18","format":false,"excerpt":"Download Case and Task data from Questetra BPM Suite. Introducing examples of scripts using curl command.","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\/2021\/09\/download-case-and-task-data.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\/download-case-and-task-data.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/download-case-and-task-data.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/download-case-and-task-data.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/download-case-and-task-data.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79781,"url":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","url_meta":{"origin":181437,"position":3},"title":"Table-Type","author":"Peter Glover","date":"2021-01-22","format":false,"excerpt":"Displays a table that can use the String, Numeric, Select or Date formats.","rel":"","context":"In &quot;Data Items&quot;","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.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\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79355,"url":"https:\/\/support.questetra.com\/en\/templates\/boss-evaluation-by-ballot-20160215\/","url_meta":{"origin":181437,"position":4},"title":"Boss Evaluation by Ballot","author":"Hirotaka NISHI","date":"2020-12-29","format":false,"excerpt":"Performs an evaluation for the boss is by anonymous voting. After starting up automatically, assigns the Step of [1. Enter Evaluation on Supervisor] to team members. When the evaluation is entered, automatically adds the evaluation result to the external file for aggregation. Since it deletes the input data from the\u2026","rel":"","context":"In &quot;\u30ef\u30fc\u30af\u30d5\u30ed\u30fc \u30a2\u30d7\u30ea&quot;","block_context":{"text":"\u30ef\u30fc\u30af\u30d5\u30ed\u30fc \u30a2\u30d7\u30ea","link":"https:\/\/support.questetra.com\/ja\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-boss-evaluation-by-ballot-20160215-209-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\/2019\/09\/eye-catch-boss-evaluation-by-ballot-20160215-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-boss-evaluation-by-ballot-20160215-209-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-boss-evaluation-by-ballot-20160215-209-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-boss-evaluation-by-ballot-20160215-209-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":99135,"url":"https:\/\/support.questetra.com\/en\/versions\/version-1230\/","url_meta":{"origin":181437,"position":5},"title":"v12.3 2021-01-17 Added Auto-step that Cooperates with kintone","author":"Hirotaka NISHI","date":"2020-12-28","format":false,"excerpt":"An auto-step that can be used as the standard in the workflow platform of Advanced or higher is added. Also, Apps in which \"Rhino\" is used in the Script Task results a setting error","rel":"","context":"In &quot;Version Info&quot;","block_context":{"text":"Version Info","link":"https:\/\/support.questetra.com\/en\/category\/versions\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-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\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-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}]}}