Hello @Ram_Gurav1 ,
In config file (under settings or assets) store required column names as
PreDefined_ColumnNames = A,B,C,D.
Use a Try-Catch block.
- In try block :
PreDefined_ColumnNames | data type = List Of String
Assign
PreDefined_ColumnNames = Config(“PreDefined_ColumnNames”).ToString.Split(","c).ToList()
Use a for loop to loop through the items of PreDefined_ColumnNames
BoolVal = DataTable.Columns.Cast(Of DataColumn).Select(Function(x) x.ColumnName).ToArray().Contains(item)
Where item is a predefined column name (used from for loop)
Create a variable UnMatched_ColumnNames | data type = String
Assign
UnMatched_ColumnNames = If(BoolVal,Nothing, UnMatched_ColumnNames+“,”+item )
Outside for loop
If(String.IsNullOrEmpty(UnMatched_ColumnNames))
Use send Mail message activity and send email for UnMatched Column Names
- In catch block
Catch the exception for dataType mis-match or other errors and send exception email
Regards,
Rohith