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

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


Hi @anjasing

You can use look up datatable activity

1 Like

in general it is a filter datatable task

As alternates you can do:

  • using Lookup datatable

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

Thank you so much :slight_smile:

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