Select different Date fields

Anonymous — Mon, 08 Dec 2014 14:43:08 GMT

Hi Folks,

today I work with one Date field.
As from a selected range, the meaning of the Date field changed to another field named Date2.

I have to select the Data as follows:

From 100000 to 344999 the field Date contains the correct Date
From 350000 to 999999 the field Date2 contains the correct Date

The data should run together and named Date
to have clear structured Qlik - Data at the end of the day.

The data are collected from a *.txt file

Any idea? Thank you in advance!

Wolfgang

Re: Select different Date fields

syukyo_zhu — Mon, 08 Dec 2014 14:52:28 GMT

hi, i am not sure i understand exactely your question.

but you can try it.

temp0:

load * 1 as flag from matable where mykey>1000000 and mykey<3449999;

load * 2 as flag from matable where mykey>3500000 and mykey<9999999;

mytablefinaly:

load *, if(flag=1, date, date2) as datecorret resident temp0;

drop table temp0;

drop fields date, date2 from mytablefinaly;