Obtaining null values from the 2nd DataTable

Help Studio
, ,
1

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?

2

@chandrakala.productanalys

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

3

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

4

still showing the null values only

5

can you share the sample input and output

6

share your input files

7

Input file:sheet1
Sheet1
Sheet2
sheet2

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

8

@chandrakala.productanalys

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

image
image1085×583 25.7 KB

Output
image

Hope It Helps!!!

9

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

10

Hi,

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()

11

Build FinalDt with the Required Column Names.

image

12

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

13

Check the Column in Input Datatable

14

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