Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

LOAD *,

     Date(mydate) as mydate2

FROM....;

DROP FIELD mydate;

RENAME FIELD mydate2 TO mydate;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

LOAD *,

     Date(mydate) as mydate2

FROM....;

DROP FIELD mydate;

RENAME FIELD mydate2 TO mydate;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

stantrolav
Partner - Creator II
Partner - Creator II

Load *,

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

from... 


Hope you enjoy my experience.

stantrolav
Partner - Creator II
Partner - Creator II

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