# Combine all values from a column into single variable

**URL:** <https://community.automationedge.com/t/combine-all-values-from-a-column-into-single-variable/1821>\
**Category:** Get Help & Discuss\
**Created:** [March 20, 2020, 8:51am UTC](https://community.automationedge.com/t/combine-all-values-from-a-column-into-single-variable/1821 "2020-03-20T08:51:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![iQAditi](https://avatars.discourse-cdn.com/v4/letter/i/74df32/32.png) [@iQAditi](https://community.automationedge.com/u/iQAditi)\
**Post date:** [March 20, 2020, 8:51am UTC](https://community.automationedge.com/t/combine-all-values-from-a-column-into-single-variable/1821/1 "2020-03-20T08:51:44Z")

</div>

I have a table with 3 columns and 3 rows as shown in image.

![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/01375d3d392736128573df64a52ad45c8271ccb5.png)

I want to combine all the values in column “Code” into single variable let say **x = 102,103,104**.

How can i do this? Please suggest.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![madhavi.bade](https://avatars.discourse-cdn.com/v4/letter/m/50afbb/32.png) [@madhavi.bade](https://community.automationedge.com/u/madhavi.bade)\
**Post date:** [March 20, 2020, 10:06am UTC](https://community.automationedge.com/t/combine-all-values-from-a-column-into-single-variable/1821/2 "2020-03-20T10:06:56Z")

</div>

Hi,

We can combine all the values of column “code” in single variable by using 'Group By 'step.

In ‘Group By’ do not specify any ‘Group field’ so it will consider all the rows.  
Specify Aggregates -\>Type as Concatenate strings separated by comma.

following screenshot shows workflow, plugin configuration and output.  
Hope this answers your question

 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/b5f514098c4d64ed64f1aa23ab5732971878e452.png)

---

<div class="post-metadata">

**Author:** ![iQAditi](https://avatars.discourse-cdn.com/v4/letter/i/74df32/32.png) [@iQAditi](https://community.automationedge.com/u/iQAditi)\
**Post date:** [March 23, 2020, 8:57am UTC](https://community.automationedge.com/t/combine-all-values-from-a-column-into-single-variable/1821/3 "2020-03-23T08:57:05Z")

</div>

Yes, it worked. Thank you so much Madhavi.  
Appreciate your prompt response.