I have a specific situation where I get data from 4 files and I pick the similar columns from the 4 files into one straight table
file 1 - New Positions
file 2 - updated position
file 3- historic positions
file 4- cancelled positions
sample data - all the files has almost the same data . So it would be as below
Position ¦ date ¦ status ¦.....few more columns which is not relevant
a2002 12/12/2004
there are situation where the data gets twice because of the null dates in the cancelled position file. which I would like to avoid by suppressing nulls. But the problem is if suppress null values there are few data in the updated position file which have few dates which are null and I would not like to miss those data
Position ¦ date ¦ status ¦.....few more columns which is not relevant