Create a validation in Data Exchange

We have a requirement to create validations on source files in Data Exchange. FCCS will receive two files in Data Exchange from each country unit (one individual location in Data Exchange for each country unit). One is the data file with all the trial balance amounts (pipe delimited) and the second one is the “Control file” that will define the number of rows loaded, total amount (sum of all amounts of all rows from the data file), number of distinct entities, number of distinct accounts and so on.

We are looking for a way to perform these validations in either Data Exchange or in FCCS: