Append two columns into one column

Help
1

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

2

This activity can be useful:

1 Like
3

Hi Rahul,

Correct me if i am wrong

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

4

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…

5

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.
6

@KavithaManivel

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

CombineTwoColumns.xaml (9.7 KB)

Thanks,

Pradeep Sridharan

7

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)

8

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?

9

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)

2 Likes
10

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

Col3

1

4

2

5

3

6

11

Thanku so much. Will check

12

Hi Toby,

Its resolved my purpose thank you so much.

13

its combining columns of two different data tables

14

image
image856×493 20.8 KB

Hi I’m trying to do the same here but am not good with converting vb to c# and need it for my work could anyone convert {row.Item(0)} to C# for me?

Any help would be much appreciated! :slight_smile: