How to map a columns from one datatable to another datatable

Help
1

Hi guys,
I have two datatables
One is first DT with column names Name, age, location , country
Another datatable is second dt with column names Employee name, age by year, current location, nationality

I have two different dt with two different column names but I would like to map
Dt2 columns with dt1
Employee name to Name
Age by Year to age
Current location to location
Nationality to country

How can I do it?

2

@Abisha

May I know what are you trying to achieve after this mapping?

1 Like
3

Hi lakshman,

I will have 10 columns but I need to write value for three columns where the column names also different

1 Like
4

@Abisha

If that columns are static then you can write based on ColumnIndex also.

2 Likes
5

Hi @Abisha

You can use the join data table activity to join the two datatable with the columns you want.

Then you can write only the needed columns as @lakshman mentioned

2 Likes
6

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