Set analysis code error

[#1]

Hi All,

I have attached a picture about my problem statement.

Hope I was able to pictorially explain whats going wrong.

Please help,

Regards,

Bikash

[erichshiino]

Hi, Bikash

Sometimes, set analysis does not handle the date format very well.

I suggest you use a auxiliary field for the DW date as an integer.

In the script, where you have something like:

Load

DW_LOAD_DATE,

... ETC

, include another line

load

DW_LOAD_DATE,

num(DW_LOAD_DATE) as nDW_DATE,

... etc

Your vConvStart and vConvEnd should get max and min of this new field

=min(nDW_DATE) and = max(nDW_DATE)

Your set analysis should also change to compare nDW_DATE instead of DW_LOAD_DATE

hope this helps,

Erich