topic Re: Purge function for MonthNames in QlikView

Purge function for MonthNames

Mon, 11 May 2015 09:48:06 GMT

Hi All,

Is it possible to purge or keep the Monthnames.

e.g. if a field has value such as ABC January 2014.xls, then can we just store ABC in one field and January 2014 in another field using the purge and keep function.

Thanks,

Asma

Re: Purge function for MonthNames

jagan — Mon, 11 May 2015 10:19:59 GMT

Hi,

Try using SubField() function

LOAD

SubField(FieldName, ' ', 1) AS Value1,

SubField(FieldName, ' ', 2) AS Value2

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Purge function for MonthNames

sunilkumarqv — Mon, 11 May 2015 10:42:39 GMT

Try this

LOAD Right(Status, Index(Status, ' ', 2)) as MonthYear ,

Left(Status,3) as Abc ;

LOAD * Inline

[Status

Abc january 2013

Abc january 2014

] ;

Re: Purge function for MonthNames

Mon, 11 May 2015 10:45:11 GMT

Subfield function would work if the filenames are in the same format.

But in this case some files are in the format ABC December 2014.xls, ABC December 2015 Test.xls.

How do I separate the date part from the filename?

Re: Purge function for MonthNames

jagan — Tue, 12 May 2015 05:46:20 GMT

Hi,

If you can attach all possible scenarios then it is easier to provide the solution.

Regards,

Jagan.