I'd like to compare the following 2 files and display a comparison of the 2 files with each other.File #1:DATE       DS 2012-08-02 12013-06-23 12013-06-27 22013-06-28 22013-06-29 779File #2:DATE       DE2013-06-16 52013-06-17 12013-06-18 32013-06-19 12013-06-20 52013-06-21 62013-06-22 62013-06-23 62013-06-24 52013-06-25 92013-06-26 72013-06-27 222013-06-28 592013-06-29 3342013-06-30 11Comparison of file #1 & #2:DATE       DS   DE 2012-08-02 -    12012-08-05 -    22013-06-16 5    -  2013-06-17 1    -  2013-06-18 3    -  2013-06-19 1    -  2013-06-20 5    -  2013-06-21 6    -2013-06-22 6    -2013-06-23 6    -2013-06-24 5    -2013-06-25 9    -2013-06-26 7    12013-06-27 22   22013-06-28 59   22013-06-29 334  7792013-06-30 11   -Above the file1, DATE and DS means data selected for a particular date of how many selected. It's showing from file1 and file2 also the same, but different dates for how many deactivated (DE).Now I want to display from file1 & file2  using AWK.Date for $1 from both files, $2 from file1, $2 from file2. If a particular date is compared also it will display DE, DA.For example:DATE      DE DS2012-08-1 -   1 # Date is present in $1 from file1 but file2 is not there.                 # This is the date I want. Also I want to display a (-) for                 # DE which is not there.
Compare the similar file and not similar files display below output in awk?
awk;join