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

Fine
Pass this array row value to a for each loop
—inside the loop use a IF CONDITION like this
Item.ToString.Contains(“NA”)
If true it will go to THEN part where use this expression in the WRITE LINE activity
Yourdatatablename.Columns(arrayrowvariable.IndexOf(item)).ColumnName

Cheers @Gaurav07

@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