How to update row value as a column value to one table to another table

Help Studio
, , , ,
1

Hi Team,

I have two dataset table 1 and table2 , I want to update table 2 row value to update cloumn and value of table 1

Please help me anyone for this.

Note: I am not using excel ,for this both dataset i converted to datatable – dt.table(0), dt.table(2) like that

Table 1
image

Table 2
image

Expected Output:

image
image758×87 1.74 KB

Regards,
Raja G

2

@Raja.G

For each row in datatable on table2

Inside that use add data column on table1…in column name give currentrow(0).ToString and in default value give currentrow(1).ToString

Cheers

3

@Anil_G ,

Thanks working as expected .

Regards,
Raja G

4

@Raja.G

Glad it helped

Happy Automation

Cheers