Hi everyone, I need help on below scenario I have 2 datatables , in 1 datatable we are having appox 64 columns (it may differ as well) , added 1 new column called " status" Now i have to use vlookup using linq query between 2 datatables based on 1 column and i have to update the status column va…

@Suma1993 dt1 (In/Out Argument) dt2 (In Argument) Dim query = From row1 In dt1.AsEnumerable() Join row2 In dt2.AsEnumerable() On row1("CommonColumn").ToString() Equals row2("CommonColumn").ToString() Select row1, row2 For Each pair In query pair.row1("stat…

On using Linq query on 2 datatables

Help Activities

lrtetala (Lakshman Reddy) July 12, 2024, 2:01pm 4

Hi @Suma1993

Check the below thread

Regards,

Topic		Replies	Views
Linq query for comparing 2 datatables Activities excel , activities , question	8	2029	July 6, 2023
Linq For 2 datatables. Inserting datat from one datatable to another using one common column Studio studio , question , workflow_diff	37	1494	August 21, 2023
How to perform Vlookup using Linq instead of Lookup data table Studio studio , question , activities_panel	1	190	January 18, 2024
Vlookup using linq query Automation Hub excel , question , automation_hub	8	1246	March 16, 2023
LINQ Query for matching row from another Excel column and update the Result Community datatable , excel , activities , studio , question , community	11	1956	January 16, 2023

On using Linq query on 2 datatables

Related topics