Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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