Help me identify presence of string NA in a data row

I have used add data row activity like this

I want to check if any of the variables in this row is “NA” and I also want to get the column name for that variables

Pass this array row value to a for each loop
—inside the loop use a IF CONDITION like this
If true it will go to THEN part where use this expression in the WRITE LINE activity

Cheers @Gaurav07


Declare a Dictionary with Dictionary<String, Object> type as dictColumns

using assign you can convert the column and value of the row to the dictionary as following,

dictColumns = row.Table.Columns.Cast(Of DataColumn)().ToDictionary(Function(c) c.ColumnName, Function(c) row(c))

this will give you the column name where the value is “NA”

dictColumns.FirstOrDefault(Function(x) x.Value.ToString.Equals("NA")).Key