How to perform Vlookup using Linq instead of Lookup data table

mohamed.s-attia · January 18, 2024, 6:36pm

Hi All
Please I have 2 Data tables that have a common Column and I need to bring certain data related to this column from one DataTable to the other

DT1
Name-Email

DT2
Name-Phone

I need the output data to be
Name-Email-Phone
Data.xls.xlsx (14.4 KB)

Anil_G · January 18, 2024, 6:42pm

You can use a join datatable activity

Which will join all the data

And then use filter datatable activity to filter if you dont need some column

Cheers

Topic		Replies	Views
On using Linq query on 2 datatables Activities excel , activities , question	6	73	July 18, 2024
How to use ToLookUp Linq query? example Activities datatable , excel , activities , studio	1	884	January 19, 2022
How to make a vlookup using LINQ Studio studio , question , activities_panel	20	977	December 19, 2023
LINQ query to vlookup data from one data table to another Studio studio , question , activities_panel	2	526	April 4, 2023
How to perform a vlookup in 2 datatable Help datatable	9	8990	November 6, 2018