How to get value of corresponding row in dt

[tharani.natarajan]

I have dt that has two columns .

A	B
Insta-dm	Private
Insta	Public
Facebook-Wallpost	Public
Column A i will get it in variable (lets call variable as Str_SocialMedia).I need to take corresponding value of column B based on Str_SocialMedia.

Kindly help

[Anil_G (Anil Gorthi)]

@tharani.natarajan

Str_SocialMedia

Hi @tharani.natarajan

Read the data in dt and then use look up datatble

Activities - Lookup Data Table

“ABC” - this is where you need to give your variable

Source column index is 0 - it selects first column
target column index is 1 - it selects the second column
dt - where you have your data

output → cell Value → create a variable and assign here for the value output

cheers

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @tharani.natarajan you could use dictionary to store this as key value pairs and get the value corresponding to the key

[Gokul001 (Gokul Balaji)]

Hi @tharani.natarajan

Can you can try with lookup data Table activity

Check out the XAML file

LookupDT.xaml (8.8 KB)

Check out the video link

How to Lookup Data Table in UiPath - Full tutorial

Regards
Gokul

[Gokul_Jayakumar (Gokul Jai)]

Helllo @tharani.natarajan . You can use the Lookup data table and get the corresponding value.
Refer to this thread, you may get some idea

Lookup Data Table UiPath |Excel Automation UiPath

[Emira (Emira Gasmi)]

Hi @tharani.natarajan
Try this:

[tharani.natarajan]

Thanks for this

What if I had to check 2 columns .Can i add “And”

[Emira (Emira Gasmi)]

Yess.