{"id":5136,"date":"2026-02-24T12:25:25","date_gmt":"2026-02-24T12:25:25","guid":{"rendered":"https:\/\/www.arivonix.ai\/techsupport\/docs\/group-columns-transformation\/"},"modified":"2026-03-02T10:49:37","modified_gmt":"2026-03-02T10:49:37","password":"","slug":"group-columns-transformation","status":"publish","type":"docs","link":"https:\/\/www.arivonix.ai\/documentation\/docs\/group-columns-transformation\/","title":{"rendered":"Group Columns"},"content":{"rendered":"<section class=\"documentation-content\">\n<h1>Group Columns Transformation<\/h1>\n<p>Organize and summarize data by grouping records into meaningful categories while generating aggregated metrics for analysis.<\/p>\n<h2>Configuring Group Columns<\/h2>\n<ol>\n<li>Click the group columns icon <img decoding=\"async\" class=\"img-fluid img-screenshot\" src=\"\/documentation\/tech-image\/Tech\/Group_Columns\/image_3.92.png\/\" alt=\"Relevant visual\" \/> and select <strong>Group Columns<\/strong>.<\/li>\n<li>In the <strong>Group Columns<\/strong> window, configure the following settings:\n<ul>\n<li>Enter a <strong>Name<\/strong> for the transformation<\/li>\n<li>Provide a <strong>Description<\/strong><\/li>\n<li>Select the columns to group the data by, which determines how records will be categorized<\/li>\n<\/ul>\n<\/li>\n<li>To implement multi-level grouping, click <strong>Add More Group<\/strong> <img decoding=\"async\" class=\"img-fluid img-screenshot\" src=\"\/documentation\/tech-image\/Tech\/Group_Columns\/image_43.41.png\/\" alt=\"Relevant visual\" \/> to include additional columns.<\/li>\n<li>Define aggregated outputs:\n<ul>\n<li>Enter a new column name<\/li>\n<li>Select the aggregation type (<strong>Sum<\/strong>, <strong>Count<\/strong>, <strong>Average<\/strong>, <strong>Minimum<\/strong>, <strong>Max Count<\/strong>, <strong>Count All<\/strong>, <strong>First Non Null<\/strong>, <strong>First<\/strong>, <strong>Last<\/strong>)<\/li>\n<li>Choose the column for performing calculations<\/li>\n<\/ul>\n<\/li>\n<li>For additional metrics, click <strong>Add More Aggregations<\/strong> <img decoding=\"async\" class=\"img-fluid img-screenshot\" src=\"\/documentation\/tech-image\/Tech\/Group_Columns\/image_104.97.png\/\" alt=\"Relevant visual\" \/> to include more calculations.<\/li>\n<li>Click <strong>Save<\/strong> <img decoding=\"async\" class=\"img-fluid img-screenshot\" src=\"\/documentation\/tech-image\/Tech\/Group_Columns\/image_113.33.png\/\" alt=\"Relevant visual\" \/> to apply the grouping logic, or select <strong>Cancel<\/strong> to discard changes.<\/li>\n<\/ol>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>Group Columns Transformation Organize and summarize data by grouping records into meaningful categories while generating aggregated metrics for analysis. Configuring Group Columns Click the group columns icon and select Group Columns. In the Group Columns window, configure the following settings: Enter a Name for the transformation Provide a Description Select the columns to group the [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[178],"doc_tag":[],"class_list":["post-5136","docs","type-docs","status-publish","hentry","doc_category-workflow-designer"],"year_month":"2026-04","word_count":131,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Hari","author_nicename":"hari","author_url":""},"doc_category_info":[{"term_name":"Workflow Designer","term_url":"https:\/\/www.arivonix.ai\/documentation\/docs-category\/workflow-designer\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/docs\/5136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/comments?post=5136"}],"version-history":[{"count":2,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/docs\/5136\/revisions"}],"predecessor-version":[{"id":5327,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/docs\/5136\/revisions\/5327"}],"wp:attachment":[{"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/media?parent=5136"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/doc_category?post=5136"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.arivonix.ai\/documentation\/wp-json\/wp\/v2\/doc_tag?post=5136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}