I want to extract corresponding value of Connection name for a particular SID?

Help Activities
1

If SID = VD1 I want to extract corresponding “Connection name” for that SID

image

2

Hi @anjasing

You can use look up datatable activity

1 Like
3

in general it is a filter datatable task

As alternates you can do:

  • using Lookup datatable
    OR

Assign activity:
dictLK | Dictionary(Of String, String) =

YourDataTableVar.AsEnumerable.ToDictionary(Function (x) x("SID").toString.Trim, Function (x) x("Connection Name").toString.Trim)

then dictLK(“VD1”) will return the value

VD1 from your mentioning, but VQ1 from the table. However we can check with dictLK.ContainsKey(“ABC”) if we do have a key or not

1 Like
5

Thank you so much :slight_smile:

6

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