Append two columns into one column

append two columns into one collumn

col1: 1,2,3,4
col2: 5,6,7,8

output should be like below
col3:1,5,2,6,3,7,4,8

Kindly help me to resolve this

This activity can be useful:

1 Like

Hi Rahul,

Correct me if i am wrong

My both column will have some different values , how the join commands will work

HI @KavithaManivel

In the two datatables, if there is no common column that can be used to join the two tables, the best option is to merge the two datatables into one. However, for this, the structure should be the same.

You can use the Merge Data Table activity to get the two datasets into one…

In the Join Data Table Use option as Full

Are the column names and types same?
If so then,

  • Full - Keep all rows from DataTable1 and DataTable2 , regardless of whether the join condition is met. Null values are added into the rows from both tables that don’t have a match.

@KavithaManivel

Please find the xaml and hope it will helpful for your issue

CombineTwoColumns.xaml (9.7 KB)

Thanks,

Pradeep Sridharan

sorry this is not the expectation.

col1
1
2
3

col2
4
5
6

my output column should be
col3

1
4
2
5
3
6
(in each cell)

Hi @KavithaManivel

Col1&Col2 belong to the same data table or not?
And you want to combine them into the third column of the same data table or new data table?

Hi @KavithaManivel

I created one xmal include two workflows and hope it will be helpful.
Workflow 1:
It will combine 2 columns of the same datatable into new column of the other datatable.

Workflow2:
It will combine 2 columns of the same datatable into the first column of them.
ColumnCombine.zip (11.7 KB)

1 Like

The data’s are in excel. So output I want in another sheet like below

Col3

1

4

2

5

3

6

Thanku so much. Will check

Hi Toby,

Its resolved my purpose thank you so much.