How to merge two data tables table 1 with 1 row and table 2 with 4 rows

Help
1

hi
How To merge two data tables table1( 1 row 5 columns) table 2(4 rows 3 columns)

2

@nikhila

use Merge Data Table activity to merge data tables.

3

Hi @nikhila,

Use Merge DataTable activity with source datatable as which you want to merge and destination datatable as to where you want to merge with.

Cheers…

4

I tried, but it’s adding the data in next row
as in the screenshot (yellow highlighted is table 2 data)

image
image1366Ă—728 40.4 KB

1 Like
5

Yes, I used merge data table activity but i need merged data in the same row.

6

@nikhila,

No problem…

May i what are the column names in table 1 and table 2

8

GSTIN, PAN, Acc.no of Beneficiary are columns in table 1

Serial No. , Description and Amount in Rs are columns in table 2

9

Hi @nikhila,

Kindly refer to this URL,

would be helpful…

10

Hi @nikhila,

Was that working

11

In that table 1 has more rows than table 2, but in my case table 1 has only one row

12

No Problem,

I will send you the xaml file. two mins pls…

13

Hii @nikhila,

Please find the xaml file. Its resolved…

Merging two dt.zip (43.0 KB)

1 Like
14

Hii @nikhila,

Were you able to access the table.xaml. Is it working as you require…?

15

Yes, it’s working…

Thank you very much

16

Hi @nikhila,

That’s amazing, keep going…

17

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