null

raadwiptec — Wed, 17 Feb 2016 12:44:55 GMT

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

Re: null

maxgro — Wed, 17 Feb 2016 12:49:48 GMT

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)

topic Re: null in QlikView

null

Re: null