Linq query for gettting macthed values from a dt

Help Studio
, ,
1

can you provide the linq query for –

i need to compare two datatables with same column for example-

DT1

name id
rajkumar
shahrukh
vijay
sreeram
guru

DT2

PatientName ID
Raj kumar
Sree ram V
Guru V
Vijay T

i need to match the name columns of both DT and if the name contains any one of the word in patient name then it should be matched and give the output in a new column as matched

@ppr @supermanPunch

2

Hi @Sree_Krishnan_vellinezhi ,

Could you also provide us with the Expected Output for the Inputs Provided ?

It would help clarify the initial doubts that we would have.

3

Appeal Faxconfirmation Input - 06142022.xls (65.5 KB)
Appeal Faxconfirmation Output - 06142022.xls (42.5 KB)

want to match the patient&faxnumber column (output sheet) with input sheet by concatenating patient name and faxnumber and updating status in input sheet If yes then(Response status,success\unsuccess,mail,attachment,filename,timeanddate) if no NO update aS NO

4

@supermanPunch

This one

5

@Sree_Krishnan_vellinezhi ,

Could you check the below Workflow :
Excel_UpdateColumn_BasedOnRange.zip (36.6 KB)

Also, Do check in your Input files, that there are some values which are scoping more columns that the required ones. I have deleted the Extra values present beyond the columns present. Let me know if it needs to be included.

Also, another observation is that I couldn’t populate the updated table back to the original Excel sheet. As of now, the Updated table is in separate excel sheet that is generated.

Let us know if you need further help.

6

Helloo!
I need to filter a column based on specific formats how can i do that for eg

column1
01-01-22
12-04-22
05-08-22
06-05-22
09-06-22
Ramkumar.pdf
excelAllUpdation.xlsx

these are the values in column and i need to filter it with the dates only