Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

Load * but one field must be change

Hi,

i want to load always all fields from tables by

Load * from...

But 1 field must be change to a date. What is the best practice for it?

regards,

sam

1 Solution

Accepted Solutions

Re: Load * but one field must be change

LOAD *,

     Date(mydate) as mydate2

FROM....;

DROP FIELD mydate;

RENAME FIELD mydate2 TO mydate;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

3 Replies

Re: Load * but one field must be change

LOAD *,

     Date(mydate) as mydate2

FROM....;

DROP FIELD mydate;

RENAME FIELD mydate2 TO mydate;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

stantrolav
Contributor II

Re: Load * but one field must be change

Load *,

Date(MonthStart(DateField), 'MMM`YY') as MonthYear

from... 


Hope you enjoy my experience.

stantrolav
Contributor II

Re: Load * but one field must be change

You are too fast in answers. Well done jedi-knight.

Community Browser