Hi
I have rows contains different timestamp columns in format YYYYMMDDhhmmss.
And I'd like to create a new timestamp using another field called type.
So if type = 1 then I use one timestamp field and if type=2 then I use
another timestamp field.
And there is more. The new timestamp fields format should be YYYYMMDD.
So I can save them using MultiStore into separate directories.
I played with CASE WHEN THEN. But if I included all fields and tried to
add something after THEN I got that there are similar fields error.
So I have to create a new one.
And the second issue how to substring? Is it possible? I tried with
STREAM and awk but this is not so clean I hoped :)
--
Margus (margusja) Roo
http://margus.roo.ee
skype: margusja
+372 51 480
