Hi Team,
There is a two reports one report(1st report) has timestamp other report(2nd report) doesn't have timestamp so, extracted date from source filename..the report which doesn't have timestamp have few fields which needs to be join from 1st report and 2nd report but sometimes the 2nd report will not be received. In that case, which need to be pick up the previous day or available previous file. is there any earliest comparison and pick the values from 2nd report? what command to be used in that case?
... View more