Obtaining null values from the 2nd DataTable

After applying the ‘Join DataTable’ activity with an inner join, I compared two DataTables to extract the common values.Subsequently, upon writing the data back to Excel, the values in the second DataTable appear as null.

Anyone can assist me?


Dt=DT1.AsEnumerable.where(function(r) DT2.AsEnumerable.Any(function(a) a(“ColumnName”).ToString.Equals(r(“ColumnName”).ToString))).CopyToDataTable

Showing error like this:
Assign: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.

still showing the null values only

can you share the sample input and output

share your input files

Input file:sheet1

output:If the ‘empno’ matches in both DataTables, the corresponding data should be updated in the Excel file.


try with this below Syntax

FinalDt=DT1.AsEnumerable.Select(function(a,i) FinalDt.Clone.LoadDataRow({a(0).ToString,a(1).ToString,DT2(i)(2),DT2(i)(3)},false)).copytodatatable


Hope It Helps!!!

Assign: Input array is longer than the number of columns in this table.


Try this

FinalDt = DT1.AsEnumerable().Select(Function(a, i) FinalDt.Clone().LoadDataRow({a(0).ToString(), a(1).ToString(), DT2(i)(2).ToString(), DT2(i)(3).ToString()}, False)).CopyToDataTable()

Build FinalDt with the Required Column Names.


Error getting
Assign: Input array is longer than the number of columns in this table.

Check the Column in Input Datatable

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.