Get text from data table

Help Activities
, , , , , , , ,
1

How can we get a particular cell text from data table?

Example
Here we have a Table suppose Employee
EmpId | EmpName | EmpDob
111 | Anil |23062000
112 | Latam | 22051990

So for example we have Anil whose dob is 23062000 so the output should just be 111
So how can we get specific Id value

Thanks in Advance!!!

2

Hi @anmita ,

Have you tried to use the Lookup Datatable Activity ?

3

Hii @supermanPunch,
No have not tried with Look up

4

@anmita , Let us know what are the Input column values that you provide to get the Output Column Value.

Accordingly we can help you further with the approach.

5

Thanks @supermanPunch will try this approach!!!

6

Hi @anmita ,

You can also try the below approach to achieve the same :
EmpId (String Variable) = If(YourDT.Select(“[EmpName]='”+Yourname_variable+“'”).Count>0,YourDT.Select(“[EmpName]='”+Yourname_variable+“'”)(0)(“EmpId”),“NULL”)

Regards,
Rohith

7

Thanks its working with Lookup DataTable :+1:t2:

1 Like
8

Thanks for the approach @rohith.prabhu

9

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