Linq query to match the data and update a particular column

[taruna.mehra (Taruna Rishu Mehra)]

Hi All

I am not so good with Linq query. Can you pls advise any Linq query?

Thanks
Taruna

[vishal.kp (vishal)]

Hi @taruna.mehra ,

It would be easy for us to understand your requirement if you can perhaps provide the input and expected output.

Regards,

[Anil_G (Anil Gorthi)]

@taruna.mehra

Can you please explain a little more and may I know why do you need only linq?

Please check this post about no speed difference with using linq or loop

Benchmarking Extract Transform Load (ETL) pipelines in UiPath

Target audience: CoE Leads, RPA Solution Architects and RPA Developers Reasons to perform such benchmarks in UiPath The UiPath forum gets a lot of queries regarding the use of Linq queries to mainpulate datatables. I see many developers have fallen for the myth that Linq queries are more performant than the standard Filter Datatable activity. I started of investigating the two aforementioned techniques, but I did want to share my experience with other tools which can outperform any standard…

cheers

[taruna.mehra (Taruna Rishu Mehra)]

Hi All thanks

I have 2 columns which ever is matching I need to update one more columns based on that as NIL. Matching columns will have unique value and matching data. It has to be picked from 2 data tables

[vishal.kp (vishal)]

@taruna.mehra , refer the following thread, the use case is same:

Compare 2 table based on single column and update the values in sheet1 excel

Hi all, How to match single columns from sheet 1 and sheet2 and update the sheet2 data into sheet1. I tried full join, left join but not working. [image] sheet1 [image] sheet2 Expected output. [image] Please help me. How to do this. Thanks, Lakshmi

Regards,

[Shubham_Kinge]

@taruna.mehra
You can try Chatgpt for some complex linq query if you want.

[Vishnuraj_Pandiyarajan2 (Vishnuraj Pandiyarajan)]

Hi @taruna.mehra
As per my understand u have Two Datatables like
DT1 with Column_A ,Column_B .
DT2 with Master_A
Step:1

Step:2

Step:3

Condition:
If Column_A is matched with Master_A,then update as “Nil” in DT1 Column_B
if not matched i will mention “NA”

u can use this expression

dt1=(From row In dt1.AsEnumerable()
Let A=row("Column_A")
Let B=If(dt2.AsEnumerable().Any(Function(r) r("Master_A").ToString = row("Column_A").ToString), "NIL", "NA")
Select dt1.Clone.Rows.Add(A,B)).CopyToDataTable()

Find the Xaml

test.zip (1.8 MB)

**Note:**Based on your condition the query will change

It will be help full if we get Share Screen shot for Input and what kind of Output you want to derive in query.

Thanks
VP

[taruna.mehra (Taruna Rishu Mehra)]

Thanks I will try and will surely update you. Pls guide me further if it doesn’t work

[taruna.mehra (Taruna Rishu Mehra)]

[taruna.mehra (Taruna Rishu Mehra)]

Hi, I want where it is matched and status column is empty otherwise this column has certain data. Where this column doesnt have data and it is matching, it should set status NIL.

[taruna.mehra (Taruna Rishu Mehra)]

Test.xlsx (8.5 KB)
if you see this chart, suppose 2 columns data is matched there we are already updating status with certain data but sometimes when bot missed and there we need to update the this status column as Nil where it is blank.