Flat File comparison

Introduction

The flat files comparison will compare, in two folders, files with the same structure. More precisely, it will compare files with the same path inside the two folders.   

Flat files are text files with a column and a row separator. By default, flat files are csv files. 

Configuration file

A minimal bacmp configuration file for flat files will be as below. It will scan the default left and right folders and compare each file found with same name. 

{"comparisonType“: "Flatfile“} 

Business keys, removed and rejected columns

You can specify, for each file, columns which are business keys, rejected columns or removed columns.   
Business keys allows you to specify which records are the same in left and right file. (See Business keys for an example, it works the same as in databases).   

Removed columns will not appear at all in comparison, rejected columns will appear but values will be replaced by ‘(REJECTED)’.

Please note that the file list that appears in the ‘details’ here does not restrict the list of compared files. All files in the folders are compared, and these files only need additional details. In order to compare only some files, you can change the left and right folder, or use a file filter. See Additional properties for more details. 

Additional properties

In addition to the configurations above, there are additional properties. Most have default values that are used if the property does not appear in the file, but can also be specified to another value. Others are not used if left unspecified.