How to get the desired output

Help Studio
, ,
1

Hai Team,
I have 2 excel files
image
image

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

2

In general we can do with:

  • Join DataTable Activity
  • LINQ with/without essential Activities
3

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

4

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

5

image
the output expected

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

6

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