Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
a2002 12/12/2004
a2002 -
any suggestion
When I pull this data
you can add a field to remember the source file and manage the null data in a different way for file 4 (cancelled) and file 2 (updated)