How to get the desired output

Hai Team,
I have 2 excel files

I need Invoice Date and Invoice Invoice Amount from the FILE 1
BCD columns from file 2

the output should be file1 data followed by file2 data how to do this it should be continous columns

In general we can do with:

  • Join DataTable Activity
  • LINQ with/without essential Activities

I tried join data table but didnot get the results I required

we dont know what was done and what was failling

However, you can also try a LINQ approach.

When sharing also the expected output sample we can help more specific

the output expected

can you give me the result using any join data table only

we would recommend to crosscheck the use case as from given output we do have some doubts on it caused information loss.

Currently it looks like a side-by-side merge