Merge DataTable more than 2 DataTable?

[fairymemay (noona)]

I want to merge DataTable more than 2 DataTable ?

I want output DataTable as below.

merge DataTable.xlsx (11.3 KB)

[Yoichi]

Hi,

Hope the following sample helps you.

Sample20220307-4.zip (11.0 KB)

Regards,

[fairymemay (noona)]

@Yoichi Now output your flow as below.

If I want output as below (Map row with highlight yellow)

How to edit code?

[Yoichi]

Hi,

I had misunderstanding for your requirement. It seems datatable join matter rather than merge. Can you try the following sample?

Sample20220307-4v2.zip (11.6 KB)

Regards,

[fairymemay (noona)]

@Yoichi I have a question If my data have 10K

I think for each row it take time to run.

Can you suggest?

[Yoichi]

Hi,

Can you try LINQ as the following, for example?

Sample20220307-4v3.zip (11.3 KB)

Regards,