Searching keyword

Hi, I have two excel file,
where in Excel1 fetching the ID and searching in the Excel2 and take the PinCode and paste in the Excel1 againt the searched ID.

@Palaniyappan @HareeshMR

1 Like

Best way is VLookup @balkishan

You can do that using for each row also, but I don’t think that is a effective way to do .

Let me know if you are interested in VLookup method :slight_smile:

2 Likes

Hi @balkishan

You can use the Join Data Table activity to join the two data tables after reading each file. Join using the ID and the resulting DT will have the Pin Code you need.

next, use a for each row to loop through the data table, and pdate the pin code in DT used for excel 1.

next, write the data to the excel 1 using write range :slight_smile:

3 Likes

Yes please tell me bro.

could you please explain me more if you don’t mind Lahiru

1 Like

Please forward two excels @balkishan, will share the workflow :slight_smile:

1 Like

Hey, I guess the approach given by @HareeshMR is the best method here… I actually forgot about the Lookup :rofl: :rofl:

It’s more efficient than joining and looping through it…

2 Likes

Okay Okay No problem bro. I will follow that one…

1 Like

Here you go
hope its resolved
balkishan.zip (22.2 KB)

Cheers @balkishan