Set analysis

[mario-sarkis]

‌hey alla this is my case :

i have list of ida look like this

ID.  PeriodDate  Max interaction date

some ids has not an interaction date need to flag as 'Not contacted Client' , my expression will translate this:

if (periodedate is 6 month greater  then Max interaction date or Max interaction date ,not contacted ,contacted)

date are number form

hope you can help

[vikasmahajan]

PFA Document will help you to user stand  Set analysis.

Vikas

[elakkians]

Hi ,

Try This

if(Max interaction date > AddMonth(Perioded Date,6),'not contacted',contacted)

[HirisH_V7]

Hi ,

Check this,

By using the sample data,Creating a status column based on your requirement,

Data:
LOAD *,
IF(Num(Month([Period Date])-Month([Interaction Date]))>=6,
'Not Contacted','Contacted') as Status

 INLINE [
    ID, Period Date, Interaction Date
    1, 01/10/2016, 01/01/2016
    2, 01/07/2016, 01/01/2015
    3, 05/07/2016, 01/06/2016
    4, 01/08/2016, 01/03/2016
    5, 01/12/2016, 01/04/2016
];

Output:

HTH,

PFA,

Hriish