How to copy a datatable

Help
1

Hello all
I am trying to copy a value to a datatable after applying join. But not able to copy .Please help help to to resolve this issue sharing files also.Below are the attached zip.i want to append the values coming after applying join to a datatable.Please help me to resolve this issue
file.zip (41.0 KB)

2

Hi @mhk15

What is the error you are getting?

3

while iterating over the items of list i have copied datatable after applying join to a final datatable again for second item i am tryin to copy datatable to final datatable… but its not showing any datatable. have shared the xaml as well.

4

Hi @mhk15

Have you used filter based on copying data

Thanks
Ashwin.S

5

Since i am finding values present in list in other excel sheet as column name for that i have used filter and since for joining two datatable on the basis of certain values used join datatable.But after applying join i am not able to copy

6

file3

Here i am trying to copy values to same datatable which is created earlier. and the error is error1

7

Hi @mhk15

You need to mention the column name like this

Dt=Dt.Select(“[column name]=‘value’”). copy todatatable ()

Thanks
Ashwin.S

1 Like
8

OUTPUTSHTDATA… = finaldt.CopyToDatatable