HOW TO CONCATENATE TWO COLUMNS AND GET IT AS A NEW COLUMN IN DATA TABLE?

Hi Team,
@KarthikByggari, @karthi2612, @ovi,

I am in the situation where I am having a Datatable and I want to perform the manipulations in it.

Let’s say I have the sample datatable as below:-

Name Age
A 20
B 30
C 40
D 50

Now I want a new column have the values as:-
Name Age Merge
A 20 A20
B 30 B30
C 40 B40
D 50 D50

Now, the issue I am having is that I am having huge amount of data in the datatable and need to perform many comparative operations within the project. So I want a simple and upfront approach to achieve this.
Please help me on a high priority.

Thanks and Regards,
@hacky

1 Like

hi @hacky
Here is a sample xaml zipped folder that could resolve your issue
Its resolved
concatenate_modified.zip (13.5 KB)

I have also added you with setordinal to place the concatenated column in the excel wherever you want by mentioning the index of the column, here in this xaml i have set as 0 index so the concatenated value will be there in first column of sheet2…

Hope would help you with your issue

Cheers kindly let know if it works

3 Likes

is that working buddy @hacky or do we need to tweak the code a bit more

Cheers

1 Like

I tweaked the code a little but your code gave me accurate approAch.
Thank you bro… @Palaniyappan

1 Like

Fantastic @hacky

Kindly close this topic with comment marked solution that could help others looking for ideas under your topic…

Cheers buddy keep going

3 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.