How to do vlookup by not putting the forumula in modern activities write cell

Help Automation Ops
,
1

how to do vlookup by not putting the forumula in modern activities write cell
without writing the actual formula in write cell how to do vlookup without modern activities if the reference and lookup column is same

2

Hi @anjani_priya

Could you share the input file and expected output.

Regards

3

Hi @anjani_priya

How about LookUp Data Table activity

Regards,

4

the refernce and lookup value is same so if i use this iam not getting output

5

@anjani_priya

Read the data into datatable and then use look up datatable activity

cheers

6

sheet1.xlsx (5.6 MB)
sheet2.xlsx (11.7 KB)
from sheet2 i have to get number
in sheet one odn number is reference
in sheet2 number is reference
I have to get number in classification column of sheet1

7

I have used the same but I didnt get the data because reference is the same and lookup value is same

8

@anjani_priya

If both are aame why do you need a look up?

Directly use the value you are looking up for…

Do you want to check if value is present in a datatable?

Cheers

9

but the number of line items are more but I just want to get the common line items by vlookup

10

@anjani_priya

If you need common ones why not use a filter ? or a join

cheers

11

I have done but its taking more time because I have 3 lakh line items how to do it fastly

12

I have done this but the code is slow because data is huge

13

@anjani_priya

So what is the final outcome you need?

How do you think lookup will solve the problem?

Try using linq for filtwring dt.AsEnumerable.Where(function(x) x("ColumnName").ToString.Equals("ValueToFilter"))

For this first do a .Count>0 if yes then there are rows…to get rows you can do .CopyToDataTable

Cheers

14

Hi @anjani_priya

Try this
Forum.zip (2.1 KB)

Happy Automation :slight_smile:

15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.