For example
Excel1.xlsx
name age sex
30
40
Excel2.xlsx
name sex
frank male
ada female
I need this one
NewExcel.xlsx
name age sex
frank 30 male
ada 40 female
thanks a lot
For example
Excel1.xlsx
name age sex
30
40
Excel2.xlsx
name sex
frank male
ada female
I need this one
NewExcel.xlsx
name age sex
frank 30 male
ada 40 female
thanks a lot
For example
Excel1.xlsx
name age sex
[null] 30 [null]
[null] 40 [null]
Excel2.xlsx
name sex
frank male
ada female
I need this one
NewExcel.xlsx
name age sex
frank 30 male
ada 40 female
thanks a lot
I try to use Mergedatatable
but…
name age sex
[null] 30 [null]
[null] 40 [null]
frank [null] male
ada [null] female
@zhangfan
Welcome to the forum
we can combine these two datatables when doing the merge row by row in a custom modelling e.g. within a for each block or within a LINQ statement
Can you confirm following:
this is input data and we can rely on it?
Is ensured that both datatable do always have the same rows count and Line n and dt1 will always be combined with the Line and same row index of dt2?
Thanks for support
thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.