Multiple select query in Assign activity

[Sumit_D]

Dear Team,
please help me with below query.
i am trying to match two columns at same time from source and destination files.
i have used below image query for one column matching,
i would like to know how to write for second column as well…
so that it matches both the columns at same time and provide me the output.
please help !!!

[Sumit_D]

DT_Dynamic = destination file
str_Nametobemapped = Destination file column Name
SourceNameValue = source column value

The 2nd Column Variable is
vtext = destination file column name
text = source column value

[ptrobot]

Just use AND. E.g.

DT.Select("[First Name] = 'John' AND [Last Name] = 'Doe'")

[Sumit_D]

thank you… though it was so confusing because of “”“”“” all this string opener… but achieved somehow…
DT_Dynamic.Select(“[”+ str_NameToBeMapped+“]= '”+sourceNameValue+“’ and [”+ vShortText +“]= '”+ShortText+“'” )

[ptrobot]

You are welcome! If you find double/single quotes confusing, maybe String.Format() could make your life easier in the future.

String.Format("[{0}] = '{1}' AND [{2}] = '{3}'", str_NameToBeMapped, sourceNameValue, vShortText, ShortText)

String.Format Method (System)