Extracting column value based on the condition on other column in datatable

Help
1

I’m trying to extract column value TNO based on the condition PNO=‘12345’ from datatable.

How can i achieve this using Select?

2

Hi @tshaikh,

Use below code to get the value
Convert.ToString(Dt.select("PNO='12345'")(0)("TNO"))

Regards,
Arivu

3

Thanks i’ll check and update you.

Many Thanks,

Tabrez

Hi @tshaikh,

Use below code to get the value

Convert.ToString(Dt.select("PNO='12345'")(0)("TNO"))

Regards,

Arivu

4

You can use lookup datatable activity

:slightly_smiling_face:

5

Hi arivu,

It worked fine!!!

Many Thanks

6

Hi Arivu,

Convert.ToString(Dt.select(“PNO=‘12345’”)(0)(“TNO”))

can you explain why we use (0) in above expression?