DATE FORMAT

upaliwije — Mon, 20 Jul 2015 23:01:56 GMT

Hi Friends

In my data model following fields exists among others

PROV_MONTH PAID_MONTH

2015-01 2015-04

2015-02 2015-06

2015-03 2015-07

2015-04 2015-07

2015-05

2015-06

2015-07

IF((NUM(PAID_MONTH)-NUM(PROV_MONTH))>5,'>5 MONTHS',PROV_MONTH)As PROV_MONTH1

I have written above in my load script. and I want output as follows

PROV_MONTH1

>5 MONTHS

2015-05

2015-06

2015-07

But it does give desired results instead all months are listed. Pls help me

Re: DATE FORMAT

sunny_talwar — Tue, 21 Jul 2015 00:57:22 GMT

Altered your data a little bit. Is this what you want?

Script:

Table:

LOAD *,

If((Check2-Check1) > (5*30), '>5 MONTHS', PROV_MONTH) AS PROV_MONTH1,

(Check2-Check1) as Difference;

LOAD Date#(PROV_MONTH, 'YYYY-MM') as PROV_MONTH,

Date#(PAID_MONTH, 'YYYY-MM') as PAID_MONTH,

Num(Date#(PROV_MONTH, 'YYYY-MM')) as Check1,

Num(Date#(PAID_MONTH, 'YYYY-MM')) as Check2

Inline [

PROV_MONTH, PAID_MONTH

2014-12, 2015-04

2014-02, 2015-06

2014-09, 2015-07

2015-04, 2015-07

2015-05,

2015-06,

2015-07,

];

Also attaching the qvw for reference.

HTH

Best,

Sunny